Question: Question 6 1 p During an interview, you are asked to explain the result of the following query: SELECT S.sname, S.rating, MIN(S.age) FROM Sailors s
Question 6 1 p During an interview, you are asked to explain the result of the following query: SELECT S.sname, S.rating, MIN(S.age) FROM Sailors s WHERE S.age > 18 GROUP BY S.rating HAVING COUNT()1; What is the right answer? O Find the age of the sailors who have at least two rating and older than 18 years old. O This query is not functional since age is not in the GROUP BY list o For each rating that has at least two sailors, find the rating and age of the youngest sailor who is older than 18 years old O Find the ratings and ages of sailors who are the youngest but older than 18 years old O This query is not functional since sname is not in the GROUP BY list
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
