We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
I don't know why this is wrong. the logic is correct and the result return what are expected, but hackerrank says wrong answer.
Am I joke to you??
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 ASC;
The PADS
You are viewing a single comment's thread. Return to all comments →
I don't know why this is wrong. the logic is correct and the result return what are expected, but hackerrank says wrong answer.
Am I joke to you??
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 ASC;