CodeSignal-Databases-solution

Solutions of CodeSignal's databases section

Some Gotcha's

Quotes in sql - single quote is for string literals and double quote or backticks(MySQL only) are used when case sensitivity is required. Usually table name and columns name are not case sensitive.

Name		Name	Last commit message	Last commit date
Latest commit History 9 Commits
10_mischievousNephews.sql		10_mischievousNephews.sql
11.suspectsInvestigation.sql		11.suspectsInvestigation.sql
12.suspectsInvestigation2.SQL		12.suspectsInvestigation2.SQL
13_securityBreach.sql		13_securityBreach.sql
14_testCheck.sql		14_testCheck.sql
15_expressionsVerification.sql		15_expressionsVerification.sql
16_newsSubscribers.sql		16_newsSubscribers.sql
17_countriesInfo.sql		17_countriesInfo.sql
18_itemCounts.sql		18_itemCounts.sql
19_usersByContinent.sql		19_usersByContinent.sql
1_projectList.sql		1_projectList.sql
20_movieDirectors.sql		20_movieDirectors.sql
21_travelDiary.sql		21_travelDiary.sql
22_soccerPlayers.sql		22_soccerPlayers.sql
23_marketReport.sql		23_marketReport.sql
2_countriesSelection.sql		2_countriesSelection.sql
3_monthlyScholarships.sql		3_monthlyScholarships.sql
4_projectsTeam.sql		4_projectsTeam.sql
5_automaticNotifications.sql		5_automaticNotifications.sql
6_volleyballResults.sql		6_volleyballResults.sql
7_mostExpensive.sql		7_mostExpensive.sql
8_contestLeaderboard.sql		8_contestLeaderboard.sql
9_gradeDistribution.sql		9_gradeDistribution.sql
README.md		README.md