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

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (3 attachments)

PDF file Icon

1209_60bca5b6e9ef8_564967.pdf

180 KBs PDF File

Excel file Icon

1209-M-S-D-A(8997).xlsx

300 KBs Excel File

Word file Icon

1209_60bca5b6e9ef8_564967.docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!