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