Question: Write SELECT statements that implement the following queries. Write one statement for each question. ( 1 ) Find the names of all the departments that

Write SELECT statements that implement the following queries. Write one statement for each question.
(1) Find the names of all the departments that located in Sydney.
(2) Find employee number and name for the employees who work on both projects 1002 and 1004.
(3) Find employee number and name (in uppercase) for all employees who were born after 1990. Format
the results in the descending order of their names.
(4) For each department, find the department name and total budgets of the projects allocated for the
department.
(5) Find the names of the all employees who work in the department GAMES, and work on the projects that
the budgets are more than $100000.
(6) Find the number and name for the employees who have no project.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!