The following shows Amaal Al-Amin’s data 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 9
The following shows Amaal Al-Amin’s data 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.)
id name age gpa absences detentions
368 Amaal Al-Amin 16 4.00 NULL 2
Which of the following WHERE clauses would include Amaal’s row when used in a SELECT query? Check all that apply.
1 point
- WHERE gpa > 3.50 AND absences < 3
- WHERE gpa < 3.50 OR absences < 3
- WHERE absences < 3
- WHERE gpa < 3.50 AND absences < 3
- WHERE NOT absences < 3
- WHERE gpa > 3.50 OR absences < 3