********SQL ORACLE************

Exercises for Chapter 8 As you do the exercises, unless it is stated otherwise, you will be using the tables from our standard Student- Course database. Also, as you do the exercises, it will be a good idea to copy/paste your query as well as your query result into a word processor. 8-1 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. 8-2 How many juniors (class 3) are there in the Student table? 8-3 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, 3, and so on) 8-4 Print the counts of As, B's, and so on from the Grade report table 8-5. Print the counts of course numbers offered in descending order by count. Use the Section table only. 8-6. Create a table with names and number-of-children (NOCD. Populate the table with five or six rows. Use COUNT SUM, AVG, MIN, and MAX on the NOC attribute in one query and check that the numbers you get are what you expect 8-7. 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 8-8. Print an ordered list of instructors and the number of As they assigned to students. Order the output by number of As Clowest to greatest. You can (and probably will ignore instructors who assign no As