Trying to write a query in access so that I can extract the data from the database of information below. I need to extract the first name and last name, student id, course Major, and GPA of all students on athletic scholarship. Sorting by Course Major, Last name, then First Name in a single sort.

I added the query I created and I received an error message. Can someone please help?

Student Table Data Student Table Datavm GPA Table Data Student Number . : Major Scholarship Table Data Academic Scholarship . Athletic Scholarship . 1002 1003 1004 1005 1006 Yes History Music Accounting Yes Economics Yes Business No No No Yes No Yes GPA Table Data -Student Table Dataym GPATableData Scholarship Table Student Number Current GPA class 1002 1003 1004 1005 1006 1007 3.96 3.25 2.96 3.88 2.67 1.94 Sophomore Junior Senior Graduate Student Junior Senior Scholarship Table Data Student Table Data (GPA Table Data f m Scholarship Table Data) Student Number MajorAcademic Scholarship Athletic Scholarship - Yes No 1002 Yes History Music Accounting Yes Economics Yes Business No 1003 Yes 1004 No 1005 No No Yes 1006 1007 SELECT (Student Table Data)-(First Name). (Student Table Data) [Last Namel, (Student Table Data] [Student Number]. [Scholarship Table DataL/Majorl [GPA Table Datal.[Current GPA FROM (Student Table Data), IScholarship Table Data], [GPA Table Data] Where [Student Table Data] [Student Number)-IGPA Table Data).[Student Numberj AND (GPA Table Datal(Student Number)-(Scholarship Table Datal,J/Student Number) AND [Scholarship Table Data). [Athletic Scholarship]-Yes ORDER BY (Scholarship Table Data].[Major], (Student Table DataL./Last Name], (Student Table Data] (First Namel