Help with Oracle SQL*Plus Query assignment

Hey,


I'm currently working on a lab assignment for class.


Assignment is located here:
hal.cs.camosun (dot) bc.ca/~weston/comp155/tyo/Lab3.html


The assignment states to write 3 queries in both the SQL:1999 version and the SQL Traditional (older version)


I didn't read that part, and so I created 3 queries and I don't know which ones are 1999 and which ones are traditional.


I would really appreciate it if someone helps me sort this problem out


So overall I need to have 6 queries in total. 3 for the SQL 1999 version and 3 for the SQL traditional (older) version


1.)


SELECT e.last_name, e.job_id, e.department_id, d.department_name
FROM employees e JOIN departments d
ON (e.department_id = d.department_id)
JOIN locations l
ON (d.location_id = l.location_id)
WHERE LOWER(l.city) = 'toronto';


2.)


SELECT e.last_name, d.department_name
FROM employees e, departments d
WHERE e.department_id = d.department_id AND last_name LIKE 'G%';


3.)


SELECT e.last_name "Employee", e.employee_id "Emp#", m.last_name "Manager", m.employee_id "Mgr#"
FROM employees e INNER JOIN employees m
ON e.manager_id = m.employee_id
AND UPPER(e.last_name) LIKE 'G%';


Thanks