Stratascratch SQL exercise solutions

Regular practise to level up my SQL skills with problems from StrataScratch.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

Stratascratch SQL exercise solutions

About

Releases

Packages

Name		Name	Last commit message	Last commit date
Latest commit History 24 Commits
.sqlfluff		.sqlfluff
3rd_most_reported_health_issues_9701.sql		3rd_most_reported_health_issues_9701.sql
README.md		README.md
above_average_but_not_at_the_top_9985.sql		above_average_but_not_at_the_top_9985.sql
activity_rank_10351.sql		activity_rank_10351.sql
arizona_california_and_hawaii_employees_9918.sql		arizona_california_and_hawaii_employees_9918.sql
best_selling_item_10172.sql		best_selling_item_10172.sql
city_with_most_amenities_9633.sql		city_with_most_amenities_9633.sql
consecutive_days_2054.sql		consecutive_days_2054.sql
delivering_and_placing_orders_2037.sql		delivering_and_placing_orders_2037.sql
differences_in_movie_ratings_9606.sql		differences_in_movie_ratings_9606.sql
distance_per_dollar_10302.sql		distance_per_dollar_10302.sql
employees_without_benefits_9981.sql		employees_without_benefits_9981.sql
exclusive_amazon_products_9608.sql		exclusive_amazon_products_9608.sql
fans_vs_opposition_10062.sql		fans_vs_opposition_10062.sql
find_fare_differences_on_the_titanic_using_a_self_join_9603.sql		find_fare_differences_on_the_titanic_using_a_self_join_9603.sql
find_favourite_wine_variety_10037.sql		find_favourite_wine_variety_10037.sql
find_the_5th_highest_salary_without_using_top_or_limit_9855.sql		find_the_5th_highest_salary_without_using_top_or_limit_9855.sql
find_the_average_number_of_friends_a_user_has_9822.sql		find_the_average_number_of_friends_a_user_has_9822.sql
find_the_average_rating_of_movie_stars_9605.sql		find_the_average_rating_of_movie_stars_9605.sql
find_the_date_with_the_highest_opening_stock_price_9613.sql		find_the_date_with_the_highest_opening_stock_price_9613.sql
find_the_day_of_the_week_that_most_people_check_in_9762.sql		find_the_day_of_the_week_that_most_people_check_in_9762.sql
find_the_most_profitable_location_2033.sql		find_the_most_profitable_location_2033.sql
find_the_number_of employees_who_received_the_bonus_and_who_didn't_10081.sql		find_the_number_of employees_who_received_the_bonus_and_who_didn't_10081.sql
find_the_percentage_of_rides_for_each_weather_and_the_hour_10019.sql		find_the_percentage_of_rides_for_each_weather_and_the_hour_10019.sql
find_the_percentage_of_shipable_orders_10090.sql		find_the_percentage_of_shipable_orders_10090.sql
find_the_second_highest_salary_without_using_order_by_9857.sql		find_the_second_highest_salary_without_using_order_by_9857.sql
find_the_top_5_highest_paid_and_top_5_least_paid_employees_in_2012_9979.sql		find_the_top_5_highest_paid_and_top_5_least_paid_employees_in_2012_9979.sql
from_microsoft_to_google_2078.sql		from_microsoft_to_google_2078.sql
growth_of_airbnb_9637.sql		growth_of_airbnb_9637.sql
highest_earning_merchants_2094.sql		highest_earning_merchants_2094.sql
highest_paid_city_employees_9989.sql		highest_paid_city_employees_9989.sql
host_popularity_rental_prices_9632.sql		host_popularity_rental_prices_9632.sql
host_response_rates_with_cleaning_fees_9634.sql		host_response_rates_with_cleaning_fees_9634.sql
keywords_from_yelp_reviews_9612.sql		keywords_from_yelp_reviews_9612.sql
lowest_revenue_generated_restaurants_2036.sql		lowest_revenue_generated_restaurants_2036.sql
lyft_driver_salary_and_service_tenure_10018.sql		lyft_driver_salary_and_service_tenure_10018.sql
marketing_campaign_success_advanced_514.sql		marketing_campaign_success_advanced_514.sql
median_salary_9900.sql		median_salary_9900.sql
most_expensive_and_cheapest_wine_10041.sql		most_expensive_and_cheapest_wine_10041.sql
most_popular_room_types_9763.sql		most_popular_room_types_9763.sql
most_popular_streets_9709.sql		most_popular_streets_9709.sql
most_senior_and_junior_employee_2044.sql		most_senior_and_junior_employee_2044.sql
naive_forecasting_10313.sql		naive_forecasting_10313.sql
name_to_medal_connection_9952.sql		name_to_medal_connection_9952.sql
new_and_existing_users_2028.sql		new_and_existing_users_2028.sql
norwegian_alpine_skiers_9955.sql		norwegian_alpine_skiers_9955.sql
olympic_medals_by_chinese_athletes_9959.sql		olympic_medals_by_chinese_athletes_9959.sql
olympics_gender_ratio_9953.sql		olympics_gender_ratio_9953.sql
percentage_of_total_spend_9899.sql		percentage_of_total_spend_9899.sql
points_rating_of_wines_over_time_10045.sql		points_rating_of_wines_over_time_10045.sql
popular_posts_2073.sql		popular_posts_2073.sql
popularity_percentage_10284.sql		popularity_percentage_10284.sql
positive_ad_channels_10013.sql		positive_ad_channels_10013.sql
premium_vs_freemium_10300.sql		premium_vs_freemium_10300.sql
quarterback_with_the_longest_throw_9966.sql		quarterback_with_the_longest_throw_9966.sql
rank_variance_per_country_2007.sql		rank_variance_per_country_2007.sql
retention_rate_2053.sql		retention_rate_2053.sql
revenue_over_time_10314.sql		revenue_over_time_10314.sql
seat_availability_2088.sql		seat_availability_2088.sql
the_most_popular_client_id_among_users_using_video_and_voice_calls_2029.sql		the_most_popular_client_id_among_users_using_video_and_voice_calls_2029.sql
time_between_two_events_9784.sql		time_between_two_events_9784.sql
top_3_facilities_9716.sql		top_3_facilities_9716.sql
top_3_wineries_in_the_world_10042.sql		top_3_wineries_in_the_world_10042.sql
top_percentile_fraud_10303.sql		top_percentile_fraud_10303.sql
top_teams_in_the_rio_de_janeiro_2016_olympics_9960.sql		top_teams_in_the_rio_de_janeiro_2016_olympics_9960.sql
trips_in_consecutive_months_2076.sql		trips_in_consecutive_months_2076.sql
unique_highest_salary_9919.sql		unique_highest_salary_9919.sql
unique_salaries_9898.sql		unique_salaries_9898.sql
videos_removed_on_latest_date_2105.sql		videos_removed_on_latest_date_2105.sql
viewers_turned_streamers_2012.sql		viewers_turned_streamers_2012.sql
views_per_keyword_9791.sql		views_per_keyword_9791.sql
wfm_brand_segmentation_based_on_customer_activity_2038.sql		wfm_brand_segmentation_based_on_customer_activity_2038.sql
year_over_year_churn_10017.sql		year_over_year_churn_10017.sql

NikolaMitsch/stratascratch-sql-excercises

Folders and files

Latest commit

History

Repository files navigation

Stratascratch SQL exercise solutions

About

Topics

Resources

Stars

Watchers

Forks

Releases

Packages 0

Packages