Scribd
Upload
78 views1 page

Join SQL Query

The document contains instructions to create several SQL queries: to display project names, locations, and responsible departments; employee information including SSN, full name, and department name; department IDs and names along with manager names; department names and projects under their control; employees directly supervised by "Kamel Mohamed"; and employees and their projects ordered by last name working on projects in Cairo including project number, controlling department name, department manager last name, address and birthdate.

Uploaded by

Asmaa Mohamed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
78 views1 page

Join SQL Query

The document contains instructions to create several SQL queries: to display project names, locations, and responsible departments; employee information including SSN, full name, and department name; department IDs and names along with manager names; department names and projects under their control; employees directly supervised by "Kamel Mohamed"; and employees and their projects ordered by last name working on projects in Cairo including project number, controlling department name, department manager last name, address and birthdate.

Uploaded by

Asmaa Mohamed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

SQL Server

Try to create the following Queries:

 Display all the projects names, locations and the department name
which is responsible about it.

.Display the following Employee Information 

SSN Employee Full Department Name


Name

 Display the Department id, name and id and the name of its
manager.

 Display the name of the departments and the name of the projects
under its control.

 Find the names of the employees who directly supervised with


Kamel Mohamed (self join).

Retrieve a list of employees and the projects they are working on 


.ordered by last name of employee

 For each project located in Cairo City, find the project number, the
controlling department name, the department manager last name,
address and birthrate.

You might also like