Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

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

More Books

Students also viewed these Databases questions