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 gpa 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 16 4.00 NULL 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