Sql for database Build a query of all students on athletic scholarship. Addition

Question

Sql for database
Build a query of all students on athletic scholarship. Additionally, produce a report with descriptive report and column headings. Be sure there is enough data to prove the selection and sort worked as required. Submit the database in unzipped format as well as submitting screenshots of the query and the report.

Step 1
Extr
act the First and Last Name, Student ID, Course Major and GPA of all students on athletic scholarship. Sort by Course Major, Last Name, then First Name in a single sort
Step 2
Produce a report with the data from Step 1 and use good headings

i dont need tables or data. i already have all the data. all i need is the sql code to pull the queries ans report together access

Explanation / Answer

Assuming that there is already a table with name "Athletic_scholarship"

Step1

SELECT FirstName,LastName,StudentID,CourseMajor,GPA
FROM Athletic_Scholarship
ORDER BY CourseMajor,Lastname,FirstName

Step2

>>Total Students
SELECT COUNT(LastName)
FROM Athletic_Scholarship

>>Total number of students by CourseMajor
SELECT COUNT(LastName)
FROM Athletic_Scholarship
GROUP BY CourseMajor

>>Top 5 students with their GPA
SELECT TOP 5 FirstName, LastName, GPA
FROM Athletic_Scholarship
ORDER BY GPA

>>The student IDs with GPA greater than X
SELECT StudentID
FROM Athletic_Scholarship
WHERE GPA > X

>>No of Students who got GPA greater than X
SELECT COUNT(StudentID)
FROM Athletic_Scholarship
WHERE GPA > X

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.