#22 The PADS | HackerRank SQL Solutions #sql #MYSQL #DATABASE #SELECT #hackerrank #C #C++ #JAVA

#SQL #MYSQL #DATABASE #SELECT #hackerrank #C #C++ #JAVA

SELECT *
FROM DEV19;

*Keep Studying...

Code is here :

Please follow us

Thanks for watching us ...
Dev19🖤

[ahmetgunay]

select name || '(' || substr(occupation, 1, 1) || ')' as name_occupation
from occupations
order by name;

select 'There are a total of ' || count(occupation) || ' ' || lower(occupation) || 's.'
from occupations
group by occupation
order by count(occupation), occupation asc;

[sravanibodapati]

Getting error with code you have provided
Select Concat(name, "(", left(name, 1), ")") from occupations order by name;