Display a list of courses (course names) that have prerequisites and the number of prerequisites for each course. Order the list by the number of prerequisites.

How many juniors (class = 3) are there in the Student table?

Group and count all MATH majors by class and display the count if there are two or more in a class. (Remember that class here refers to freshman, sophomore, and so on and is recorded as 1, 2, and so on.)

Print the counts of As, Bs, and so on from the Grade_report table.

Print the counts of course numbers offered in descending order by count. Use the Section table only.

Create a table with names and number-of-children (NOC). Populate the table with five or six rows. Use COUNT, SUM, AVG, MIN, and MAX on the NOC attribute in one query and confirm that the numbers you get are what you expect.

Create a table of names, salaries and job locations. Populate the table with at least 10 rows and no fewer than three job locations. (There will be several employees at each location.) Find the average salary for each job location with one SELECT.

Print an ordered list of instructors and the number of As they assigned to students. Order the output by number of As (lowest to greatest). You can (and probably will) ignore instructors that assign no As.

Create a table called Employees with a name, a salary and job title. Include exactly six rows. Make the salary null in one row, the job title null in another, and both the salary and the job title in another. Use this data:

Name	Salary	Title
Mary	1000	Programmer
Brenda	3000
Stephanie		Artist
Alice
Lindsay	2000	Artist
Christina	500	Programmer

Find the instructor and the section where the maximum number of As were awarded.

Find the COUNT of the number of students by class who are taking classes offered by the computer science (COSC) department. Perform the query in two ways: once using a condition in the WHERE clause and once filtering with a HAVING clause. (Hint: These queries need a five-table join.)