Question: (5 points) (Note: Read the schema of each table in the university database from ddl.sql or using schema before working on this problem.) Write the

 (5 points) (Note: Read the schema of each table in the

(5 points) (Note: Read the schema of each table in the university database from ddl.sql or using schema before working on this problem.) Write the following queries in SQL, using the university schema. (You should actually check the queries you write on the database.) (a) names of instructors whose names have at least 5 characters. (b) total number of instructors. (c) number of instructors whose names are distinct. (d) names and salary of instructors by decreasing order of salary and if two instructors have same salary then by ascending order of their names. (e) Find the third highest salary of any instructor

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!