SQL-HackerRank HackerRank SQL Solution by wpang Subdomains Problem Solution Note Basic Select Revising the Select Query II MS SQL Server select from where and Select All MS SQL Server select * Select By ID MS SQL Server Japanese Cities' Attributes MS SQL Server Japanese Cities' Names MS SQL Server Weather Observation Station 1 MS SQL Server Weather Observation Station 3 MS SQL Server id%2 for MS SQL, mod(id,2) for ORACLE Weather Observation Station 4 MS SQL Server count Weather Observation Station 5 MS SQL Server length order top 1 Weather Observation Station 6 MS SQL Server distinct where like '[AEIOU]%' Weather Observation Station 7 MS SQL Server right(, 1) in ('','') Weather Observation Station 8 MS SQL Server and Weather Observation Station 9 MS SQL Server '[^AEIOU]%' Weather Observation Station 10 MS SQL Server not in Weather Observation Station 11 MS SQL Server not() logic either not or not Weather Observation Station 12 MS SQL Server logic neither nor Higher Than 75 Marks MS SQL Server order by right(, 3), id asc Employee Names MS SQL Server order by string (default asc) Employee Salaries MS SQL Server Advanced Select The PADS MS SQL Server concat select "str", count() group by order by , Occupations MS SQL Server pivot table Aggregation Revising Aggregations - The Sum Function MS SQL Server select sum() where str = '' Revising Aggregations - Averages MS SQL Server avg Average Population MS SQL Server round down to integra floor() Japan Population MS SQL Server Population Density Difference MS SQL Server The Blunder MS SQL Server ceiling, cast(() as decimal), replace(str,'0','') Top Earners MS SQL Server Weather Observation Station 2 MS SQL Server format(,'.##') Weather Observation Station 13 MS SQL Server between and Weather Observation Station 14 MS SQL Server Weather Observation Station 15 MS SQL Server Weather Observation Station 16 MS SQL Server Weather Observation Station 17 MS SQL Server Weather Observation Station 18 MS SQL Server Manhattan Distance max()-min() or abs( - ) Weather Observation Station 19 MS SQL Server Euclidean Distance, power( , 2), sqrt(), square(), cannot use ()^2 for int Weather Observation Station 20 MS SQL Server median Basic Join African Cities MS SQL Server inner join, in(), on = Average Population of Each Continent MS SQL Server avg(), group by The Report MS SQL Server select case when then else end, order by desc Top Competitors MS SQL Server group by, having, order by have same name with select Ollivander's Inventory MS SQL Server double select from same tables (as different name) Challenges MS SQL Server MS SQL Server Alternative Queries Draw The Triangle 2 MS SQL Server declare @row int =, while() begin, set @row += 1, end, replicate MS SQL Server MS SQL Server MS SQL Server Big Query Regex Queries MS SQL Server Regex Performance of Joins MS SQL Server JOIN EACH The Query MS SQL Server MS SQL Server MS SQL Server MS SQL Server MS SQL Server MS SQL Server
