The following shows just a few rows from a table for students in a school. (GPA is grade point average, where 4.0 means the student is getting the highest scores possible. Absences is how many days the student has not attended school, and detention is a punishment for bad behavior.)
Question 7
The following shows just a few rows from a table for students in a school. (GPA is grade point average, where 4.0 means the student is getting the highest scores possible. Absences is how many days the student has not attended school, and detention is a punishment for bad behavior.)
students
id name age g​pa absences detentions
930 Olufunmilayo Ayton 16 4.00 3​ 2​
667 Vincent Michaelson 15 2.53 12 0​
907 Asa Quigg 15 3.57 1 0
168 Kiran Patil 17 3.28 0 3
368 Amaal Al-Amin 1​6 4​.00 N​ULL 2​
Check all the students whose rows would be included in the results of
SELECT name FROM students WHERE absences < 2;
1 point
- Olufunmilayo Ayton
- Vincent Michaelson
- Asa Quigg
- Kiran Patil
- Amaal Al-Amin
