Which SQL commands would be used to accomplish these tasks? Find IDs and names of all
Question:
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
Database management systems
ISBN: 978-0072465631
3rd edition
Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff