Question: Create an appropriate query that returns a list of all students in all sections. Specifically, it should return the student's first and last name, the
Create an appropriate query that returns a list of all students in all sections. Specifically, it should return the student's first and last name, the course name, the section number, and the student's grade in the section. Return the data to Excel as a table. Then, inside the table, create a new column that is a concatenation of first name and last name, and create a pivot table that allows you to find the average grade for each student?
Step by Step Solution
3.47 Rating (176 Votes )
There are 3 Steps involved in it
StudFirstName StudLastName CourseName SectionNumber Grade Student name Nancy Davolio Second Year Music Theory 1560 93279999 Nancy Davolio Nancy Davolio Survey Of Physics 2071 66410004 Nancy Davolio Na... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (3 attachments)
1209_60bca5b6e9ef8_564967.pdf
180 KBs PDF File
1209-M-S-D-A(8997).xlsx
300 KBs Excel File
1209_60bca5b6e9ef8_564967.docx
120 KBs Word File
