For this assignment, I want you to answer the following questions by executing a SQL query against the three-table example database we have been working with in class

Subject:Computer SciencePrice: Bought3

Share With

For this assignment, I want you to answer the following questions by executing a SQL query against the three-table example database we have been working with in class.  For each query, take a screenshot of your output, paste it into a Word document, and then save the document with all your answers as a PDF.  You will submit the PDF to this assignment.

Here are the questions:

1. What are the first and last names of all the students?
2. What are the first and last names of all the students?  Make the column headers on the output read "First Name" and "Last Name"
3. What are the first and last names of all the sophomores?
4. What grades has each student received in their classes (first name, last name, and grade)?
5. What students have not taken a course (first and last name of ONLY the students that have not taken a course)?
6. What grades has each student received in their classes (first name, last name, course name, and grade)?
7. How many classes has each student taken (first name, last name, and course count)?
8. What student (first name and last name) has taken the most courses?  Don't list all students here, just the student or students with the most courses.
9. What is the total number of credit hours each course has generated regardless if they have generated any or not (course name and the total number of credit hours)?
10. Students are assigned to counselors by their last names.  Students with last names starting with A through M go to Ms. Chavez while students with last names starting with N through Z go to Mr. Myagi.  What students go to each counselor (first name, last name, counselor name)? Use a CASE statement to generate this query.

 

 

CAN YOU PLEASE HELP ME WRITE THE SQL QUERY?