Skip to content

Instantly share code, notes, and snippets.

@Nader93

Nader93/The PADS-hackerrank.sql

Last active May 2, 2019 07:03
Show Gist options
  • Save Nader93/dcbd73e8ee7faa6b2905f463de9fe7fd to your computer and use it in GitHub Desktop.
Save Nader93/dcbd73e8ee7faa6b2905f463de9fe7fd to your computer and use it in GitHub Desktop.
Download ZIP
The PADS hackerrank solution
Raw
The PADS-hackerrank.sql
select concat(name,"(",left(OCCUPATION,1),")")
from OCCUPATIONS
order by name asc;
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