Consider a database table named Student with the following attributes: student_name – Name of the student gender – Gender ('M' or 'F') class_code…

1. A student who was absent has no score, i.e. test_score is NULL:

SELECT *
FROM Student
WHERE gender = 'M' AND test_score IS NULL;

2. Names and marks of students who passed:

SELECT student_name, test_score
FROM Student
WHERE test_score > 40;

3. Minimum, average and maximum per class (aggregates skip NULL scores):

SELECT class_code,
       MIN(test_score) AS min_score,
       AVG(test_score) AS avg_score,
       MAX(test_score) AS max_score
FROM Student
GROUP BY class_code;

— rhs