HackerRank SQL Problem's Solutions
Here I will share my solutions of HackerRank SQL problems.
Course Curriculum
- 1 SQL Select Query - Select all column
- 2 SQL Select Query - Select a single column
- 3 Select All data of a table
- 4 SQL Select By ID
- 5 Japanese Cities' Attributes
- 6 Japanese Cities' Names - SELECT the name column
- 7 Query city and state from STATION
- 8 Query data which id is even using SQL MOD() function
- 9 SQL Count unique data by using count() and DISTINCT
- 10 Query shortest and longest data by using LENGTH(), ORDER BY, LIMIT
- 11 SQL Query starting with vowels using REGEX
- 12 Query ending with vowels using SQL LOWER() and SUBSTRING() Function
- 13 Query data starting and ending with vowels using SQL LOWER(), LENGTH() and SUBSTRING() functions
- 14 Query data that don't start with vowels using SQL LOWER() and SUBSTRING() functions and NOT IN Operator
- 15 Query data that don't end with vowels using SQL LOWER() and SUBSTRING() functions and NOT IN Operator
- 16 Query data either don't start or don't end with vowels
- 17 Query data don't start and don't end with vowels
- 18 Query Students who get higher than 75 marks by using SUBSTRING() and LENGTH() functions
- 19 Query all employe names from Employee table in alphabetical order using ORDER BY
- 20 Query all employe names from Employee table having salary greater than $2000