Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Graph Databases New Opportunities For Connected Data

Authors: Ian Robinson, Jim Webber, Emil Eifrem

2nd Edition

1491930896, 978-1491930892

More Books

Students also viewed these Databases questions

Question

Identify cultural barriers to communication.

Answered: 1 week ago