Query Syntax Flashcards
1
Q
HAVING
A
SELECT LastName, SUM(PointsScored) AS ps
FROM Roster
GROUP BY LastName
HAVING ps > 0;
Google Cloud Bigquery > Query Syntax > Flashcards
HAVING
SELECT LastName, SUM(PointsScored) AS ps
FROM Roster
GROUP BY LastName
HAVING ps > 0;