Answered step by step
Verified Expert Solution
Question
1 Approved Answer
airecey Tom one Staff (Stald FirstName, LastName, City, Phone, Email, Fax, Salary, Dento) Department (DentNo. DentName Phone Fax Location Address) wed as 1 Project (Projectld.
airecey Tom one Staff (Stald FirstName, LastName, City, Phone, Email, Fax, Salary, Dento) Department (DentNo. DentName Phone Fax Location Address) wed as 1 Project (Projectld. Title, Duration, Location Extension) Task (Stafid Proiectld StartDate. Completion Date) data at the entity ween Using the above schema, write SQL queries that will answer process the following cepts of 1. List staff id, first name, and fax of all stafts. [1 Mark] t of one 2. List all department names in the department table but eliminate duplicates. [1 Mark] n with eared 3. List department name and location of all departments ordered by location in descending order input 4. List all details of all of the staffs that are in the city of Sohar. [2 Marks] 5. List all details of projects that are located in Sur. Burain and Sohar. [1 Mark] 6. List last name and phone of all the staffs along with the titles of the projects. [2 Marks] 7. List all details about departments whose name has the letter d' in the third last position. [2 Marks] 8. List the salary of top 10 staff members. [2 Marks] 9. List all details about projects with project ids betiveen 2 and 6. wh Mark)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started