Question: Consider the following table: 2 0 points Instructors table [ [ ID , name,deptName,salary ] , [ 1 2 1 2 1 , Alije

Consider the following table:
20 points
Instructors
\table[[ID,name,deptName,salary],[12121,Alije Wu,Finances,90000.00],[15151,John Mozart,Music,40000.00],[22222,Frank Einstein,Physics,95000.00],[32343,El Said,History,60000.00],[33456,Chelsea Dunn,Physics,90000.00]]
Write a single SQL query to list in alphabetic order the names of all instructors. Note that every column of Instructors should be included in the result.
 Consider the following table: 20 points Instructors \table[[ID,name,deptName,salary],[12121,Alije Wu,Finances,90000.00],[15151,John Mozart,Music,40000.00],[22222,Frank Einstein,Physics,95000.00],[32343,El

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To list the names of all instructors in alphabetical or... View full answer

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!