1. Create a report using the wizard or based on an SQL query that that shows Courses that instructors are approved to teach. Show Course Number, First Name, and Last Name of Instructor.
2. Create a report using the wizard or based on an SQL query that shows student information and what their major is. Show Student First Name, Student Last Name, and Major.
3. Create a report using the wizard or based on an SQL query that that shows student information by Zip code. Zip codes shall be in increasing order. Show Student First Name, Student Last Name, and Zip code (in Ascending Order).
4. Create a report using the wizard or based on an SQL query that that shows the Course Name and the students' First Name and Last Name in each. Sort Course Number in increasing order.
5. Create a report using the wizard or based on an SQL query that that shows status for each student. The student should be in alphabetical order by last name, then first name.