️ HackerRank is a practice site for multiple computer languages including Python, R, and, of course, SQL. All questions were solved using MySQL. Question: Given the CITY and COUNTRY tables, query the ...
MAX(CASE WHEN OCCUPATION = 'Doctor' THEN NAME END) AS DOCTOR, MAX(CASE WHEN OCCUPATION = 'Professor' THEN NAME END) AS PROFESSOR, MAX(CASE WHEN OCCUPATION = 'Singer' THEN NAME END) AS SINGER, MAX(CASE ...
Getting good at SQL for interviews can feel like a puzzle. You know the basics, but putting them together in a way that impresses people is another thing entirely. Luckily, there are great tools out ...