Question 6 1 p During an interview, you are asked to explain the result of the f

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 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.

Explanation / Answer

Answer: C

For each rating that has at least two sailors, find the rating and age of the yougest sailor sailor who is older than 18 years old

explanation:

count(*) returns the count of all records...at the rating and age >18

so..this must be greater than 1...

since this table is about..sailors..so it can be number of sailors..

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.