Which SQL commands would be used to accomplish these tasks? 

 

Find IDs and names of all students taking ART103A.

 

Find the numbers of all the classes taught by Byrne of the Math department.

 

Get IDs of all faculty who are assigned to the History department or
who teach in room H221.

 

Find the names and IDs of all faculty members who teach a class in room H221.

 

Find the number of departments that have faculty in them.

 

Find the student with the largest number of credits.

 

Change Tanaka's department to MIS and rank to Assistant.

 

Give all students three extra credits.

Insert a new Faculty record with ID of F330, name of Jones, department of CSC, and rank of Instructor

 

Order the faculty records in descending (DESC) order based on department

Answer rating: 100% (QA)

1 To find IDs and names of all students taking ART103A you would use a SELECT command and join the student table with the registration or classes tabl... View the full answer