This lab uses the university database.
- Think before you run it: the average instructor salary is 78000. How many instructors earn more than that? Read the
instructortab. - The instructors who earn more than the average salary:
name, thensalary. Let a subquery compute the average. - The students who have more credits (
tot_cred) than the average student:name, thentot_cred. - Every department with its budget and how far it is below the largest budget:
dept_name,budget, then the difference. - The name of the student with the most credits.