 Start all queries with SELECT * as per the narrated PowerPoint slides. Part 1: Queries Note: Use the actual words in t

[answerhappygod]

 Start all queries with SELECT * as per the narrated
PowerPoint slides.
Part 1: Queries Note: Use the actual words in the query. For
example in #1 & 2 use the word "Gemini", not the project number
in order to avoid joining the tables. Remember, the purpose of this
is to practice joins and subqueries. Also, go back and review in
the PowerPoint slides on subqueries what an actual subquery is.
Many people get low grades on this lab as they do not actually
write a subquery.
Write a query to:
5. Get the enter dates of all clerks that belong to department
d1 using a join.
6. Repeat #5 using a subquery.
Employee table:

Start All Queries With Select As Per The Narrated Powerpoint Slides Part 1 Queries Note Use The Actual Words In T 1 (20.8 KiB) Viewed 35 times

Works on table:

Start All Queries With Select As Per The Narrated Powerpoint Slides Part 1 Queries Note Use The Actual Words In T 2 (24.94 KiB) Viewed 35 times

100% 1 2 3 4 5 6 r Results 1 emp_no 9031 10102 11222 12388 18316 25348 30550 Messages emp_fname emp_Iname dept_no Elisa Bertoni d2 Ann Jones d3 Trent Johnson d2 Tom Hawkins d3 John Bamimore d1 Matthew Smith d3 CL

1 2 3 4 5 6 Results Messages project_no job p1 emp_no 9031 9031 p2 9031 p3 10102 p1 10102 p3 18316 p2 enter_date Manager 1998-04-15 00:00:00.000 NULL 2008-09-30 17:19:04.867 Clerk 1997-11-15 00:00:00.000 Analyst 1997-10-01 00:00:00.000 Manager 1999-01-01 00:00:00.000 NULL 1998-06-01 00:00:00.000