Write a query to show the student name and email for the student with a student

Question

Write a query to show the student name and email for the student with a student number of 111223333.

Write a query to list all students with a GPA of 3.0 or higher. The GPA is the StudentQualityPts divided by StudentCreditHours. Include in the query the columns of StudentName and GPA. Sort the list by GPA

Write a query to show the number of students and the average GPA for those students whose name begins with the letters “Jo”

Write a query that groups entries in the ENROLL table based on the grade. The result of this query should show the number of entries for each grade. Include only those groups that have five or more entries receiving a particular grade.

Student Table Enroll Table Class Table StudentNumber (PK) StudentNumber (PK, FK) Class Code (PK StudentName ClassCode (PK, FK Class Section Mail EnrollGrade Numb Room Student QualityPts Class Name StudentCreditHours

Explanation / Answer

1) select StudentName,StudentEMail from Student where StudentNumber = 111223333;

2) select StudentName, StudentQualityPts /StudentCreditHours as GPA from Student where StudentQualityPts/StudentCreditHours>=3.0 order by GPA;

3) select StudentName,avg(StudentQualityPts /StudentCreditHours) as GPA from Student where StudentName LIKE 'Jo%';

4) select count(*), EnrollGrade from Enroll group by EnrollGrade having count(*)>=5;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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