Skip to content

Instantly share code, notes, and snippets.

@susanta96

susanta96/The PADS Solutions.txt

Created December 16, 2018 18:34
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save susanta96/f3358e487cb20456d36596dc6eaaccdf to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save susanta96/f3358e487cb20456d36596dc6eaaccdf to your computer and use it in GitHub Desktop.
Download ZIP
Raw
The PADS Solutions.txt
SELECT concat(NAME,concat("(",concat(substr(OCCUPATION,1,1),")"))) FROM OCCUPATIONS ORDER BY NAME ASC;
SELECT "There are a total of ", count(OCCUPATION), concat(lower(occupation),"s.") FROM OCCUPATIONS GROUP BY OCCUPATION ORDER BY count(OCCUPATION), OCCUPATION ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment