Create an appropriate query that returns a list of all students in all sections. Specifically, it should

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 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?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Analytics Data Analysis and Decision Making

ISBN: 978-1305947542

6th edition

Authors: S. Christian Albright, Wayne L. Winston

Question Posted: