SQL

Here are some useful SQL data analysis tasks from different platforms like LeetCode, StrataScratch, ITResume, Stepik and others.

Name		Name	Last commit message	Last commit date
CancellationRate_TaxiTrips.ipynb		CancellationRate_TaxiTrips.ipynb
ChurnRate_SQL.txt		ChurnRate_SQL.txt
Clients_Average_Session_Time.txt		Clients_Average_Session_Time.txt
Delete_Duplicate_Emails.txt		Delete_Duplicate_Emails.txt
Exchange Seats_SQL.txt		Exchange Seats_SQL.txt
Fill_NULLs_with_previous_value.ipynb		Fill_NULLs_with_previous_value.ipynb
Fill_NULLs_with_previous_value.txt		Fill_NULLs_with_previous_value.txt
GENERATE_SERIES_to_find_median.sql		GENERATE_SERIES_to_find_median.sql
Human_Traffic_of_Stadium.txt		Human_Traffic_of_Stadium.txt
Median_SQL.txt		Median_SQL.txt
Multiply_All_Values_In_Column_SQL.txt		Multiply_All_Values_In_Column_SQL.txt
Nth_Highest_Salary.txt		Nth_Highest_Salary.txt
README.md		README.md
RetentionRate_Cohorts.txt		RetentionRate_Cohorts.txt
RollingAverage_SQL.txt		RollingAverage_SQL.txt
Salesforce_1.ipynb		Salesforce_1.ipynb
Salesforce_2.ipynb		Salesforce_2.ipynb
Salesforce_3.ipynb		Salesforce_3.ipynb
TOP 3 authors who sold the most books in total.txt		TOP 3 authors who sold the most books in total.txt
TransposeTable.txt		TransposeTable.txt
TransposeTable_LongtoWide.txt		TransposeTable_LongtoWide.txt
[Тестовое_Альфа-банк]_Средняя_стоимость_5_покупки.txt		[Тестовое_Альфа-банк]_Средняя_стоимость_5_покупки.txt

Navigation Menu