Specify the following queries in SQL on the University database 1. Retrieve the names of all courses taught by professor
Posted: Mon Jul 11, 2022 9:49 am
Specify the following queries in SQL on the Universitydatabase
1. Retrieve the names of all courses taught by professor King inFall 21.
2. Retrieve names of students who took Discrete Mathematics Iwith Professor King
3. Retrieve the names and major departments of students whonever fail in any class.
4. For each section taught by Professor Anderson, retrieve thenumber of students who took the section
5. Retrieve department names and the number of courses offeredby the department
1. Retrieve the names of all courses taught by professor King inFall 21.
2. Retrieve names of students who took Discrete Mathematics Iwith Professor King
3. Retrieve the names and major departments of students whonever fail in any class.
4. For each section taught by Professor Anderson, retrieve thenumber of students who took the section
5. Retrieve department names and the number of courses offeredby the department