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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!