Leetcode_SQL

Solutions for SQL50 Leetcode

Each problem statement and solution are done one after the another. It is done for my upcoming data engineering and data scientist interviews

Name		Name	Last commit message	Last commit date
Latest commit History 90 Commits
AIRBNB_medium_day5.sql		AIRBNB_medium_day5.sql
Amazon_ads_performance_leetcode_1322.sql		Amazon_ads_performance_leetcode_1322.sql
Amazon_dodgy_lastpersonelevator_Leetcode1204.sql		Amazon_dodgy_lastpersonelevator_Leetcode1204.sql
Amazon_easy_Stock_gainloss_Leetcode.sql		Amazon_easy_Stock_gainloss_Leetcode.sql
Amazon_game_play_analysis_leetcode511_512.sql		Amazon_game_play_analysis_leetcode511_512.sql
Amazon_hard_Employeelogs_longeststreak.sql		Amazon_hard_Employeelogs_longeststreak.sql
Amazon_hard_Movieratinganduser_Leetcode1341.sql		Amazon_hard_Movieratinganduser_Leetcode1341.sql
Amazon_hard_customertracking.sql		Amazon_hard_customertracking.sql
Amazon_hard_runningtotalboysgirls_Leetcode1308.sql		Amazon_hard_runningtotalboysgirls_Leetcode1308.sql
Amazon_hard_trustedcontacts_Leetcode1364.sql		Amazon_hard_trustedcontacts_Leetcode1364.sql
Amazon_hard_winningstreak.sql		Amazon_hard_winningstreak.sql
Amazon_medium_DeliveryII_Leetcode1174.sql		Amazon_medium_DeliveryII_Leetcode1174.sql
Amazon_medium_customers_who_bought_A_not_B_Leetcode1398.sql		Amazon_medium_customers_who_bought_A_not_B_Leetcode1398.sql
Amazon_medium_directindirectreport_Leetcode1270.sql		Amazon_medium_directindirectreport_Leetcode1270.sql
Amazon_medium_exchange_seats_Leetcode626.sql		Amazon_medium_exchange_seats_Leetcode626.sql
Amazon_medium_latest_price_for_product_leetcode1164.sql		Amazon_medium_latest_price_for_product_leetcode1164.sql
Amazon_medium_monthly_transactionI_Leetcode1193.sql		Amazon_medium_monthly_transactionI_Leetcode1193.sql
Amazon_medium_most_ordered_item_Leetcode1596.sql		Amazon_medium_most_ordered_item_Leetcode1596.sql
Amazon_medium_pagerecom_Leetcode1264.sql		Amazon_medium_pagerecom_Leetcode1264.sql
Amazon_medium_rolling_avg_restro_Leetcode1321.sql		Amazon_medium_rolling_avg_restro_Leetcode1321.sql
Amazon_medium_teams_points_Leetcode1212.sql		Amazon_medium_teams_points_Leetcode1212.sql
Amzon_day10_medium_returninguser.sql		Amzon_day10_medium_returninguser.sql
Avant_data_insertion.sql		Avant_data_insertion.sql
Avant_intermediate_q1.sql		Avant_intermediate_q1.sql
Avant_table_creation.sql		Avant_table_creation.sql
Average_price_items_sold_LeetcodeEasy.sql		Average_price_items_sold_LeetcodeEasy.sql
CTE_SQL_vimp_interviews.sql		CTE_SQL_vimp_interviews.sql
Cuat_reff.txt		Cuat_reff.txt
Cust_no_transactions.txt		Cust_no_transactions.txt
Day1_LeetCode_TOP.sql		Day1_LeetCode_TOP.sql
Day1_Leetocde_useractivity.sql		Day1_Leetocde_useractivity.sql
Fat_recyclable.txt		Fat_recyclable.txt
Google_day3.sql		Google_day3.sql
KPMG_medium_sechighestdeptsal.sql		KPMG_medium_sechighestdeptsal.sql
Leetcode_1076_amazon_easy_project_with_max_experience.sql		Leetcode_1076_amazon_easy_project_with_max_experience.sql
Leetcode_hard_consecutive_days_of_people_visit_greater100.sql		Leetcode_hard_consecutive_days_of_people_visit_greater100.sql
Leetcode_hard_tournament_winner.sql		Leetcode_hard_tournament_winner.sql
Lowest_highest_populated_cities.sql		Lowest_highest_populated_cities.sql
Med_Amazon_highestgrossingprod2.sql		Med_Amazon_highestgrossingprod2.sql
Medium_Walmart_reporting_manager.sql		Medium_Walmart_reporting_manager.sql
Meta_hard_commentsperuser.sql		Meta_hard_commentsperuser.sql
Microsoft_day6.sql		Microsoft_day6.sql
Percentage_of_users_Leetcode.sql		Percentage_of_users_Leetcode.sql
Quote_Status_VIMP.sql		Quote_Status_VIMP.sql
README.md		README.md
SCD_interview_question_freelancerworkrate.sql		SCD_interview_question_freelancerworkrate.sql
Shell_medium_consecutiveabsence.sql		Shell_medium_consecutiveabsence.sql
Student_exam_apps		Student_exam_apps
Tesla_med_day7.sql		Tesla_med_day7.sql
Uber_hard_rmse_day4.sql		Uber_hard_rmse_day4.sql
Uber_tips_weekdayweekends.sql		Uber_tips_weekdayweekends.sql
actual_distance.sql		actual_distance.sql
adobe_simple.sql		adobe_simple.sql
air_bnb_csv_to_row.sql		air_bnb_csv_to_row.sql
amazon_15_runningtotal.sql		amazon_15_runningtotal.sql
amazon_day2.sql		amazon_day2.sql
amazon_duplicate_rowpick.sql		amazon_duplicate_rowpick.sql
amazon_easy_project_analysis_III_leetcode1077.sql		amazon_easy_project_analysis_III_leetcode1077.sql
amazon_easy_rising_temperature_Leetcode197.sql		amazon_easy_rising_temperature_Leetcode197.sql
amazon_easy_sales_analysis_I_Leetcode_1082.sql		amazon_easy_sales_analysis_I_Leetcode_1082.sql
amazon_fibonacci.sql		amazon_fibonacci.sql
amazon_hard_highestgrossprod.sql		amazon_hard_highestgrossprod.sql
amazon_hard_marketingcampaignsuccess.sql		amazon_hard_marketingcampaignsuccess.sql
amazon_med_users_ordered_in_2019_leetcode1158.sql		amazon_med_users_ordered_in_2019_leetcode1158.sql
amazon_medium_Article_viewsII_Leetcode1149.sql		amazon_medium_Article_viewsII_Leetcode1149.sql
amazon_medium_call_from_to_leetcode1699.sql		amazon_medium_call_from_to_leetcode1699.sql
amazon_missing_id.sql		amazon_missing_id.sql
amazon_prime_subscription_rate.sql		amazon_prime_subscription_rate.sql
author_viewed.txt		author_viewed.txt
average_processing_time.txt		average_processing_time.txt
avg_years_exp_ofguys_inproj.sql		avg_years_exp_ofguys_inproj.sql
basic_SQL_exp_q.sql		basic_SQL_exp_q.sql
bonus_below_1000.txt		bonus_below_1000.txt
cancellation_rate_uber.sql		cancellation_rate_uber.sql
company_with_increasing_revenue.sql		company_with_increasing_revenue.sql
customer_retention_1.sql		customer_retention_1.sql
delete_duplicates_2soln.sql		delete_duplicates_2soln.sql
distance_cities_cte_selfjoin.sql		distance_cities_cte_selfjoin.sql
doordash_medium.sql		doordash_medium.sql
doordash_medium_avgamount_datewise.sql		doordash_medium_avgamount_datewise.sql
e1_amazon_maxtrans.sql		e1_amazon_maxtrans.sql
e2_amazon_leadlag_displayimprovedstudents.sql		e2_amazon_leadlag_displayimprovedstudents.sql
e3_amazon_productsoldonbothdays.sql		e3_amazon_productsoldonbothdays.sql
e4_amazon_latestbalance.sql		e4_amazon_latestbalance.sql
e5_amazon_usersbuyingdifproddifdays.sql		e5_amazon_usersbuyingdifproddifdays.sql
e5_pt2_userbuyingsameprodsdiffdays.sql		e5_pt2_userbuyingsameprodsdiffdays.sql
easy_Apple_totalusers_perclientpermonth.sql		easy_Apple_totalusers_perclientpermonth.sql
easy_FAANG_empsalmorethanmanagersal.sql		easy_FAANG_empsalmorethanmanagersal.sql
easy_JPMC_cardsissued.sql		easy_JPMC_cardsissued.sql
easy_uber_rownum.sql		easy_uber_rownum.sql
emp_present_hospital.sql		emp_present_hospital.sql
epam_systems_basic.sql		epam_systems_basic.sql
exchange_seats.sql		exchange_seats.sql
first_call_last_call.sql		first_call_last_call.sql
friends_score_greater100.sql		friends_score_greater100.sql
game_play_analysisIV.sql		game_play_analysisIV.sql
gender_percentage.sql		gender_percentage.sql
goldman_med_hard_currencyexchangerates.sql		goldman_med_hard_currencyexchangerates.sql
heirarchy_employee_manager.sql		heirarchy_employee_manager.sql
highest_lowest_sal_cte_window.sql		highest_lowest_sal_cte_window.sql

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

Leetcode_SQL

About

Releases

Packages

Languages

srijit43/Leetcode_SQL

Folders and files

Latest commit

History

Repository files navigation

Leetcode_SQL

About

Resources

Stars

Watchers

Forks

Releases

Packages 0

Languages

Packages