Question: Make a structured query language (SQL) for the following question in Access Database (ill put into access database myself, just need the SQL): (I have

Make a structured query language (SQL) for the following question in Access Database (ill put into access database myself, just need the SQL): (I have provided the necessary info in screenshots. Screenshot 1 is the relationships, 2 is Attendance table, 3 is Courses table, 4 is Employees table).

QUESTION 5) List top 5 employees who have passed the most number of courses (Last, First, [Number of courses]).

Here is what i have done so far (I DID EVERYTHING EXCEPT TOP 5, PLEASE SHOW ME HOW TO PICK TOP 5 EMPLOYEES THAT PASSED COURSES):

SELECT Last, COUNT(Passed) AS TotalCoursesPassed FROM Employees, Attendance WHERE Employees.SSN = Attendance.SSN AND Passed = YES GROUP BY LastMake a structured query language (SQL) for the following question in AccessDatabase (ill put into access database myself, just need the SQL): (Ihave provided the necessary info in screenshots. Screenshot 1 is the relationships,2 is Attendance table, 3 is Courses table, 4 is Employees table).

All Access Obje H Employee: NAL CMIA Ascending Tis X Del Relati 1/1/2000 $3100.00 $6.110.00 9/23 1998 3/1/1956 $2,800.00 2/23/1997 810N1997 $3,400.00 2/1/1957 $3.200.00 $0.00 Ary do

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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

Students Have Also Explored These Related Databases Questions!