Start all queries with SELECT * as per the narrated PowerPoint slides. Note: Use the actual words in the query. For exam

[answerhappygod]

Start all queries with SELECT * as per the narrated
PowerPoint slides.
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:
3. Get the first and last names of all employees that work in
Research or Accounting using a join.
4. Repeat #3 using a subquery
employee table:

Start All Queries With Select As Per The Narrated Powerpoint Slides Note Use The Actual Words In The Query For Exam 1 (20.8 KiB) Viewed 34 times

department table:

Start All Queries With Select As Per The Narrated Powerpoint Slides Note Use The Actual Words In The Query For Exam 2 (12.36 KiB) Viewed 34 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

100% Results dept no 1 d1 2 d2 3 d3 لا Messages dept_name location Research Dallas Accounting Seattle Marketing Dallas