Name		Name	Last commit message	Last commit date
Latest commit History 179 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
133_query to print all the prime numbers between 1 and 10.sql		133_query to print all the prime numbers between 1 and 10.sql
134_derive the net balance based on the credit or debit of the amount.sql		134_derive the net balance based on the credit or debit of the amount.sql
135_Write SQL to turn the columns English, Maths, and Science into rows.sql		135_Write SQL to turn the columns English, Maths, and Science into rows.sql
136_find the trade for the same stock that happened in a range of 10 sec and price difference more than 10 percent.sql		136_find the trade for the same stock that happened in a range of 10 sec and price difference more than 10 percent.sql
137_derive start_date and end_date column when there is continuous amount in bank balance column.sql		137_derive start_date and end_date column when there is continuous amount in bank balance column.sql
138_find employees who have atleast 3 consecutive salary increase.sql		138_find employees who have atleast 3 consecutive salary increase.sql
139_determine the number of consecutive occupied seat IDs and the total count of these seats.sql		139_determine the number of consecutive occupied seat IDs and the total count of these seats.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
140_find total number of rows for all joins (with null values in the table).sql		140_find total number of rows for all joins (with null values in the table).sql
141_find the missing ids from the input table.sql		141_find the missing ids from the input table.sql
142_ display the Source_Phone_Nbr and a flag based on the fisrt and last call.sql		142_ display the Source_Phone_Nbr and a flag based on the fisrt and last call.sql
143_display the sequence number from the given range of numbers.sql		143_display the sequence number from the given range of numbers.sql
144_compare source and target table.sql		144_compare source and target table.sql
145_find the number which is appearing consecutively three or more time.sql		145_find the number which is appearing consecutively three or more time.sql
146_find the items which was bought consecutively three or more time.sql		146_find the items which was bought consecutively three or more time.sql
147_write a query to get the output in the given format.sql		147_write a query to get the output in the given format.sql
148_quote status based on multiple order status (2 methods).sql		148_quote status based on multiple order status (2 methods).sql
149_school seat arrangement by teacher.sql		149_school seat arrangement by teacher.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
150_print movie theatre like seating number.sql		150_print movie theatre like seating number.sql
152_Aggregate sum of sales country wise and display on maximum in each continents.sql		152_Aggregate sum of sales country wise and display on maximum in each continents.sql
153_obtain the desired result (using cross join and left join).sql		153_obtain the desired result (using cross join and left join).sql
154_calculate total club reward points (2 methods - string split and cross apply).sql		154_calculate total club reward points (2 methods - string split and cross apply).sql
155_find the app or mode and the count for highest amount of transactions in each location.sql		155_find the app or mode and the count for highest amount of transactions in each location.sql
156_ecommerce frequent customers visiting the app for purchase again and again.sql		156_ecommerce frequent customers visiting the app for purchase again and again.sql
157_ecommerce frequent customers visiting the app for purchase again and again (using inner join).sql		157_ecommerce frequent customers visiting the app for purchase again and again (using inner join).sql
158_write a query to print the result for each student (pivot-case statement).sql		158_write a query to print the result for each student (pivot-case statement).sql
159_write a query to calculate the percentage of results using the best of the five rule (unpivot-row_number).sql		159_write a query to calculate the percentage of results using the best of the five rule (unpivot-row_number).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
160_user purchase platform (mobile-desktop-both) spend per day analysis.sql		160_user purchase platform (mobile-desktop-both) spend per day analysis.sql
161_Find customers who placed more than one distinct product (solved using 2 methods).sql		161_Find customers who placed more than one distinct product (solved using 2 methods).sql
162_conversion rate from visitors to customers.sql		162_conversion rate from visitors to customers.sql
163_find avg order value given customer placed more than 5 orders.sql		163_find avg order value given customer placed more than 5 orders.sql
164_days between shipped and delivered order date.sql		164_days between shipped and delivered order date.sql
165_analyze the frequency of rides during peak hours and non-peak hours.sql		165_analyze the frequency of rides during peak hours and non-peak hours.sql
166_top 3 customers who spent the most in their first month of making an order.sql		166_top 3 customers who spent the most in their first month of making an order.sql
167_analyzing product sales growth (scenario based interview question).sql		167_analyzing product sales growth (scenario based interview question).sql
168_calculate the moving average of a stock price.sql		168_calculate the moving average of a stock price.sql
169_query to Find Consecutive Days with Increasing Stock Prices.sql		169_query to Find Consecutive Days with Increasing Stock Prices.sql
16_find_the_average_distance_between_the_locations_solution_1.sql		16_find_the_average_distance_between_the_locations_solution_1.sql
170_produces a comma separated list of passengers in the lift.sql		170_produces a comma separated list of passengers in the lift.sql
171_obatin the output in the required format.sql		171_obatin the output in the required format.sql
172_find 20 percent products that contribute to 80 percent sales.sql		172_find 20 percent products that contribute to 80 percent sales.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

vishnu-t-r/sql_solved_questions

Folders and files

Latest commit

History

Repository files navigation

SQL_solved_questions

About

Topics

Resources

Stars

Watchers

Forks

Releases

Packages 0

Languages

Packages