![]()
African Cities | HackerRank Query the names of all cities on the continent 'Africa'. www.hackerrank.com Problem Given the CITY and COUNTRY tables, query the names of all cities where the CONTINENT is 'Africa'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. -> 아프리카 대륙에 있는 모든 도시의 이름을 출력하시오. Answer select a.name from city a inner join country b on a.countrycode = b.code where b.c..
![]()
Challenges | HackerRank Print the total number of challenges created by hackers. www.hackerrank.com Problem Julia asked her students to create some coding challenges. Write a query to print the hacker_id, name, and the total number of challenges created by each student. Sort your results by the total number of challenges in descending order. If more than one student created the same number of ch..
