Name		Name	Last commit message	Last commit date
Latest commit History 135 Commits
09_crypto_market_alogorithm_report.sql		09_crypto_market_alogorithm_report.sql
100_Counting Instances in Text (stratascratch).sql		100_Counting Instances in Text (stratascratch).sql
101_Most Popular Client_Id Among Users Using Video and Voice Calls (stratascratch).sql		101_Most Popular Client_Id Among Users Using Video and Voice Calls (stratascratch).sql
102_City With Most Amenities (stratascratch).sql		102_City With Most Amenities (stratascratch).sql
103_Cookbook Recipes_display page title like a book (stratascratch).sql		103_Cookbook Recipes_display page title like a book (stratascratch).sql
104_Top 5 States With 5 Star Businesses (stratascratch).sql		104_Top 5 States With 5 Star Businesses (stratascratch).sql
105_Marketing Campaign Success_Advanced (stratascratch).sql		105_Marketing Campaign Success_Advanced (stratascratch).sql
106_Find the total number of downloads for paying and non-paying users by date (stratascratch).sql		106_Find the total number of downloads for paying and non-paying users by date (stratascratch).sql
107_number of shipments per month (stratascratch).sql		107_number of shipments per month (stratascratch).sql
108_Find the number of times each word appears in drafts_cross apply (stratascratch).sql		108_Find the number of times each word appears in drafts_cross apply (stratascratch).sql
109_Identify returning active users (Finding User Purchases-stratascratch).sql		109_Identify returning active users (Finding User Purchases-stratascratch).sql
10_employees_under_a_given_manager_recursion.sql		10_employees_under_a_given_manager_recursion.sql
110_Customer order details (stratascratch).sql		110_Customer order details (stratascratch).sql
111_Apple Product Counts (stratascratch - distinct used along with when).sql		111_Apple Product Counts (stratascratch - distinct used along with when).sql
112_Email activity rank (stratascratch).sql		112_Email activity rank (stratascratch).sql
113_Flags per video (stratascratch).sql		113_Flags per video (stratascratch).sql
114_coding challenge (hackerrank).sql		114_coding challenge (hackerrank).sql
115_top competitors (hackerrank).sql		115_top competitors (hackerrank).sql
116_Project planning (hackerrank).sql		116_Project planning (hackerrank).sql
117_Monthly percentage revenue difference (amazon-stratascratch).sql		117_Monthly percentage revenue difference (amazon-stratascratch).sql
118_Calculate Users By Average Session Time (stratascratch).sql		118_Calculate Users By Average Session Time (stratascratch).sql
119_Calculate Users By Average Session Time (stratascratch)-solution 2.sql		119_Calculate Users By Average Session Time (stratascratch)-solution 2.sql
11_hierarchy_of_managers_for_a_given_employee_recursion.sql		11_hierarchy_of_managers_for_a_given_employee_recursion.sql
120_5 queries on global companies table (stratascratch).sql		120_5 queries on global companies table (stratascratch).sql
121_New Products_new cars launched in current year (stratascratch).sql		121_New Products_new cars launched in current year (stratascratch).sql
122_Find the percentage of shippable orders (stratascratch).sql		122_Find the percentage of shippable orders (stratascratch).sql
123_Find max customer_id who placed single order.sql		123_Find max customer_id who placed single order.sql
124_Symmetric pairs (hackerrank).sql		124_Symmetric pairs (hackerrank).sql
125_Election result_who got the most votes and won the election.sql		125_Election result_who got the most votes and won the election.sql
126_Max transaction amount and ratio_using three methods(window function, cte, subquery).sql		126_Max transaction amount and ratio_using three methods(window function, cte, subquery).sql
127_Min_max from group and sequence (using row_number function).sql		127_Min_max from group and sequence (using row_number function).sql
128_sales amount is greater than or equal to previous year sales (multple year in table).sql		128_sales amount is greater than or equal to previous year sales (multple year in table).sql
129_comma separated list of mail ids.sql		129_comma separated list of mail ids.sql
12_parent_age_when_the_child_was_born_recursion.sql		12_parent_age_when_the_child_was_born_recursion.sql
130_write a query to digitize a result table (2 methods).sql		130_write a query to digitize a result table (2 methods).sql
131_Write a query to get the Running Total of Quantity for each ProductCode.sql		131_Write a query to get the Running Total of Quantity for each ProductCode.sql
132_write a query to print all the letters of english alphabet.sql		132_write a query to print all the letters of english alphabet.sql
13_records_of_brands_whose_amount_increase_from_one_year_to_another.sql		13_records_of_brands_whose_amount_increase_from_one_year_to_another.sql
14_record_of_brand_whose_amount_increase_every_year_only_increasing_solution_1.sql		14_record_of_brand_whose_amount_increase_every_year_only_increasing_solution_1.sql
15_record_of_brand_whose_amount_increase_every_year_only_increasing_solution_2.sql		15_record_of_brand_whose_amount_increase_every_year_only_increasing_solution_2.sql
16_find_the_average_distance_between_the_locations_solution_1.sql		16_find_the_average_distance_between_the_locations_solution_1.sql
17_find_the_average_distance_between_the_locations_solution_2.sql		17_find_the_average_distance_between_the_locations_solution_2.sql
18_find_unique_distance_between_source_and_destination-manage_reverse_pair.sql		18_find_unique_distance_between_source_and_destination-manage_reverse_pair.sql
19_finding_delta_records_in_table_using_exists_join_except.sql		19_finding_delta_records_in_table_using_exists_join_except.sql
20_delta_records.sql		20_delta_records.sql
21_customer(s)_with_the_highest_order_price_for_orders_placed_within_10_years_of_the_first_order.sql		21_customer(s)_with_the_highest_order_price_for_orders_placed_within_10_years_of_the_first_order.sql
22_display_student_of_top_40_percent_category.sql		22_display_student_of_top_40_percent_category.sql
23_find_employee_name_starting_with_vowels.sql		23_find_employee_name_starting_with_vowels.sql
24_name_of_manager_for_emp_using_self_join.sql		24_name_of_manager_for_emp_using_self_join.sql
25_forward_fill_values_for_null_records_dealing_with_missing_values.sql		25_forward_fill_values_for_null_records_dealing_with_missing_values.sql
26_find_maximum_from_multiple_columns.sql		26_find_maximum_from_multiple_columns.sql
27_sort_result_based_on_alphanumeric_column.sql		27_sort_result_based_on_alphanumeric_column.sql
29_items_that_are_brought_together_frequently_market_basket_analysis.sql		29_items_that_are_brought_together_frequently_market_basket_analysis.sql
30_delete_duplicate_records_from_base_table.sql		30_delete_duplicate_records_from_base_table.sql
31_fetch_only_odd_or_even_charters_from_a_string_in_table.sql		31_fetch_only_odd_or_even_charters_from_a_string_in_table.sql
32_comapare_avg_dept_monthly_salary_and_avg_company_monthly_salary.sql		32_comapare_avg_dept_monthly_salary_and_avg_company_monthly_salary.sql
33_shortest_distance_between_two_points_in_plane.sql		33_shortest_distance_between_two_points_in_plane.sql
34_find_employees_who_earn_the_top_three_salaries_in_each_department.sql		34_find_employees_who_earn_the_top_three_salaries_in_each_department.sql
35_tableu_using_and_not_using_context_filter.sql		35_tableu_using_and_not_using_context_filter.sql
36_mercedespetronas_to_mreeptoa.sql		36_mercedespetronas_to_mreeptoa.sql
37_find_n_consecutive_days.sql		37_find_n_consecutive_days.sql
38_report_the_students_being_quiet_in_exams.sql		38_report_the_students_being_quiet_in_exams.sql
39_3_concecutive_days_people_count_more_than_100_in_a_stadium.sql		39_3_concecutive_days_people_count_more_than_100_in_a_stadium.sql
40_how_many_visited_the_bank_and_did_one_transaction_and_so_on(visit_count_vs_transaction_count).sql		40_how_many_visited_the_bank_and_did_one_transaction_and_so_on(visit_count_vs_transaction_count).sql
41_datespine_filling_missing_date_and_sales_data_calculate_avg_sales.sql		41_datespine_filling_missing_date_and_sales_data_calculate_avg_sales.sql
42_pivot_operator.sql		42_pivot_operator.sql
43_dynamic_pivot_query.sql		43_dynamic_pivot_query.sql
44_reset_the_running_total_on_11th_of_every_month.sql		44_reset_the_running_total_on_11th_of_every_month.sql
45_reset_running_total_when_profit_become_negative.sql		45_reset_running_total_when_profit_become_negative.sql
46_avg_dept_salary_in_parent_table_with_subquery.sql		46_avg_dept_salary_in_parent_table_with_subquery.sql
47_organisational_str_hierarchy_with_recursive_cte.sql		47_organisational_str_hierarchy_with_recursive_cte.sql
48_salary_grtr_or_lss_than_avg_dept_salary_without_using_join_and_window_function.sql		48_salary_grtr_or_lss_than_avg_dept_salary_without_using_join_and_window_function.sql
49_employees_who_are_also_managers_from_employee_table.sql		49_employees_who_are_also_managers_from_employee_table.sql
50_employee_receiving_the_highest_bonus.sql		50_employee_receiving_the_highest_bonus.sql
51_percent_of_students_attend_school_on_their_birthday.sql		51_percent_of_students_attend_school_on_their_birthday.sql
52_solving_many_questions_employee_table_part1.sql		52_solving_many_questions_employee_table_part1.sql
53_report_name_of_the_winning_candidate.sql		53_report_name_of_the_winning_candidate.sql
54_add_effectiveness_by_max_avg_users_(many concepts).sql		54_add_effectiveness_by_max_avg_users_(many concepts).sql
55_avg_dept_salary_column_specification.sql		55_avg_dept_salary_column_specification.sql
56_solving_many_questions_employee_table_part2.sql		56_solving_many_questions_employee_table_part2.sql
57_assign_cutomer_tier_based_on_order_count.sql		57_assign_cutomer_tier_based_on_order_count.sql
58_retrieve_all_customers_who_placed_an_order_using_in_and_exists.sql		58_retrieve_all_customers_who_placed_an_order_using_in_and_exists.sql
59_pivot_text_values_display_list_of_names_under_a_header.sql		59_pivot_text_values_display_list_of_names_under_a_header.sql
60_find_project_start_date_and_end_date_project_planning.sql		60_find_project_start_date_and_end_date_project_planning.sql
61_find_common_records_in_two_tables_without_using_join.sql		61_find_common_records_in_two_tables_without_using_join.sql
62_count_no_of_weekends_in_current_month (recursive cte).sql		62_count_no_of_weekends_in_current_month (recursive cte).sql
63_compute_avg_salary_when_zero_missing_from_input.sql		63_compute_avg_salary_when_zero_missing_from_input.sql
64_number_of_users_who_purchased_on_multiple_days.sql		64_number_of_users_who_purchased_on_multiple_days.sql
65_how_many_times_does_a_number_occur_consecutively.sql		65_how_many_times_does_a_number_occur_consecutively.sql
66_calculate_ytd_and_mtd_totals.sql		66_calculate_ytd_and_mtd_totals.sql
67_searching_values_frm_multiple_columns_using_dynamic_sql.sql		67_searching_values_frm_multiple_columns_using_dynamic_sql.sql
68_find_most_recently_joined_employee_using_cross_apply.sql		68_find_most_recently_joined_employee_using_cross_apply.sql
69_eda_on_accident_database_analysis.sql		69_eda_on_accident_database_analysis.sql
70_delete_duplicate_records_from_master_table_using_temp_table.sql		70_delete_duplicate_records_from_master_table_using_temp_table.sql
71_equivalent_sql_query_for_include_exclude_fixed_lod.sql		71_equivalent_sql_query_for_include_exclude_fixed_lod.sql
72_average_billing_amount_for_each_customer_(per year and per bill) 2 scenario.sql		72_average_billing_amount_for_each_customer_(per year and per bill) 2 scenario.sql
73_populate_last_non_null_values_in_a_table(company column - car column)_(table - automobile).sql		73_populate_last_non_null_values_in_a_table(company column - car column)_(table - automobile).sql
74_election_result_query_one_person_vote_multiple_times (find who won).sql		74_election_result_query_one_person_vote_multiple_times (find who won).sql
75_correlated_sub-query_employees_who_earns_more_than_avg_dept_salary.sql		75_correlated_sub-query_employees_who_earns_more_than_avg_dept_salary.sql
76_ find_the_prices_of_all_products_on_a_particular_date(leetcode).sql		76_ find_the_prices_of_all_products_on_a_particular_date(leetcode).sql

vishnu-t-r/sql_solved_questions

Folders and files

Latest commit

History