Write a SQL statement to display the course numbers of classes taught by Hammett Glenn.
Question:
Write a SQL statement to display the course numbers of classes taught by Hammett Glenn. |
Write a SQL statement to display the course names of the courses taught by an instructor whose id is 415. |
Write a query to display the name and office number of all instructors who teach Psy101.(USE NATURAL JOIN) |
Write a query to display the semester and the number of courses offered in that semester. Display only the semesters that offer more than five courses. |
Write a SQL statement to display the name of each campus and the total number of rooms in that campus. |
Write a SQL statement to display the list of instructors who are approved as well as those who are not approved. (OUTER JOIN) |
Write a SQL statement to display the start date and start time of all classes taught by instructor Hammett Glenn. |
Write a SQL statement to display the number of students in each major with a status of failing. |
Write a SQL statement to display the credit hours of all courses that Hammett Glenn is approved to teach. |
Get the campus name and phone number of all rooms with numbers greater than 25. |
Accounting Information Systems
ISBN: 978-1260153156
2nd edition
Authors: Vernon Richardson, Chengyee Chang, Rod Smith