Skip to content

NikolaMitsch/stratascratch-sql-excercises

BranchesTags

Folders and files

NameName
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
 
 

Repository files navigation

Stratascratch SQL exercise solutions

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

About

Regular practise to level up my SQL skills.

Topics

sql exercises stratascratch

Resources

Readme
Activity

Stars

4 stars

Watchers

1 watching

Forks

2 forks
Report repository

Releases

No releases published

Packages

 
 
 

Contributors