Problem Statement

Youngest Adult Student Per Rating Level Consider the following table: Sid Name Age Rating 101 Smith 15 5 102 Bob 25 7 103 Mark 19 8 104 Jean 17 7 Student Which of these queries is used to find the age of the youngest student whose age is at least 18 years for each rating level with at least two such students? SELECT S.Rating, MIN (S.Age) FROM Student S WHERE S.Age >= 18 HAVING COUNT (*) > 1 SELECT S.Rating, MIN (S.Age) FROM Student S WHERE S.Age >= 18 GROUP BY S.Rating SELECT S.Rating, MIN (S.Age) FROM Student S WHERE S.Age >= 18 GROUP BY S.Rating HAVING COUNT (*) > 1 SELECT S.Rating, S.Age FROM Student S WHERE S.Age >= 18 GROUP BY S.Rating HAVING COUNT (*) > 1 Output Format Print the letter of the correct option (A, B, C, or D).