Question

SQL and Databases, please help

During an interview, you are asked to explain the result of the following query: SELECT S.sname, s.rating, MIN(S.age) FROM Sailors 5 WHERE S.age > 18 GROUP BY S.rating HAVING COUNT(*) > 1; What is the right answer? This query is not functional since sname is not in the GROUP BY list. Find the age of the sailors who have at least two rating and older than 18 years old. Find the ratings and ages of sailors who are the youngest but older than 18 years old. 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. This query is not functional since age is not in the GROUP BY list.

Answer 1

answer)This query is not functional since sname is not in the GROUP BY list

Syntax for group by is:

SELECT columnName1,columnName2,....,columnNameN function_name(columnName)
FROM tableName WHERE condition
GROUP BY columnName1,columnName2,....,columnNameN
HAVING condition
ORDER BY columnName1,columnName2,....,columnNameN;

whatever the column names that are come in select that all should come in GroupBY clause.