SELECT Email FROM Person
Without GROUP BY Email, I alway got wrong answer. What is GROUP BY, why it matters here?
Having clause should always be used with Group by as far as I know.
The HAVING clause should always come with the GROUP BY clause, to make the semantics clear. Otherwise, the SQL interpreter would not know which attribute to aggregate.
Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.