Course Details

course-thumb

HackerRank SQL Problem's Solutions

Overview
Carriculum
Instructor

Basic Select

SQL Select Query - Select all column

SQL Select Query - Select a single column

Select All data of a table

SQL Select By ID

Japanese Cities' Attributes

Japanese Cities' Names - SELECT the name column

Query city and state from STATION

Query data which id is even using SQL MOD() function

SQL Count unique data by using count() and DISTINCT

Query shortest and longest data by using LENGTH(), ORDER BY, LIMIT

SQL Query starting with vowels using REGEX

Query ending with vowels using SQL LOWER() and SUBSTRING() Function

Query data starting and ending with vowels using SQL LOWER(), LENGTH() and SUBSTRING() functions

Query data that don't start with vowels using SQL LOWER() and SUBSTRING() functions and NOT IN Operator

Query data that don't end with vowels using SQL LOWER() and SUBSTRING() functions and NOT IN Operator

Query data either don't start or don't end with vowels

Query data don't start and don't end with vowels

Query Students who get higher than 75 marks by using SUBSTRING() and LENGTH() functions

Query all employe names from Employee table in alphabetical order using ORDER BY

Query all employe names from Employee table having salary greater than $2000

Advanced Select

Aggregation

Instructor
Al-Mamun Sarkar
Lectures
20
Course level
Beginner
Last Update:
Mar 23 , 2020
Language
English

Share On: