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.
Find the names of all the departments that located in Sydney.
Find employee number and name for the employees who work on both projects and
Find employee number and name in uppercase for all employees who were born after Format
the results in the descending order of their names.
For each department, find the department name and total budgets of the projects allocated for the
department.
Find the names of the all employees who work in the department GAMES, and work on the projects that
the budgets are more than $
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
