Skip to content

Instantly share code, notes, and snippets.

@QuatoHub

QuatoHub/Quato.sql

Last active March 26, 2022 08:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save QuatoHub/5fe54aa47cf2958e4d9e295cf85349b9 to your computer and use it in GitHub Desktop.
Save QuatoHub/5fe54aa47cf2958e4d9e295cf85349b9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Quato.sql
SELECT CONCAT(NAME, "(", LEFT(OCCUPATION, 1), ")") FROM OCCUPATIONS ORDER BY NAME;
SELECT CONCAT("There are a total of ", COUNT(OCCUPATION), " ", LOWER(OCCUPATION), "s.")
FROM OCCUPATIONS GROUP BY OCCUPATION ORDER BY COUNT(OCCUPATION), OCCUPATION;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment