[ WebToolTip.com ] Udemy - SQL Interview Kit (2025) - 100 + Challenges and Solutions

File Name

Size

Get Bonus Downloads Here.url

180 B

~Get Your Files Here !/1 - Introduction/1 -Introduction.mp4

18 MB

~Get Your Files Here !/1 - Introduction/2 -How to navigate this course.mp4

24 MB

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/1Active Admin Users/active_admin_users_hint.txt

113 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/1Active Admin Users/active_admin_users_solution.txt

342 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/2Spend per Customer/spend_per_customer_hint.txt

86 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/2Spend per Customer/spend_per_customer_solution.txt

187 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/3 Payment method breakdown/payment_method_breakdown_hint.txt

73 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/3 Payment method breakdown/payment_method_breakdown_solution.txt

395 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/4Viewers and Plans/viewers_and_plans_hint.txt

75 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/4Viewers and Plans/viewers_and_plans_solution.txt

391 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/5Users Who Never Logged In/users_without_logins_hint.txt

116 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/5Users Who Never Logged In/users_without_logins_solution.txt

390 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/6Top 3 Viewed Articles per User/top_3_articles_hint.txt

218 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/6Top 3 Viewed Articles per User/top_3_articles_solution.txt

967 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/7 New vs Delayed Gym Members/gym_activation_hint.txt

181 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/7 New vs Delayed Gym Members/gym_activation_solution.txt

718 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/8All Creators and Moderators/all_creators_moderators_hint.txt

133 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/8All Creators and Moderators/all_creators_moderators_solution.txt

301 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/9 Ticket status count/daily_ticket_status_hint.txt

135 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/0Warm‑Up Challenges/9 Ticket status count/daily_ticket_status_solution.txt

440 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/10String & Regex Operations/1 Split Customer Full Name/split_full_name_hint.txt

232 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/10String & Regex Operations/1 Split Customer Full Name/split_full_name_solution.txt

343 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/10String & Regex Operations/2 Clean Raw Emails/clean_emails_hint.txt

124 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/10String & Regex Operations/2 Clean Raw Emails/clean_emails_solution.txt

157 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/10String & Regex Operations/3 Items Ordered per User/items_ordered_by_user_hint.txt

118 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/10String & Regex Operations/3 Items Ordered per User/items_ordered_by_user_solution.txt

218 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/10String & Regex Operations/4Normalize Phone Numbers/clean_phone_numbers_hint.txt

152 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/10String & Regex Operations/4Normalize Phone Numbers/clean_phone_numbers_solution.txt

231 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/10String & Regex Operations/5Replace Symbols in Feedback/replace_symbols_in_feedback_hint.txt

154 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/10String & Regex Operations/5Replace Symbols in Feedback/replace_symbols_in_feedback_solution.txt

420 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/10String & Regex Operations/6 Extract Email Username/extract_email_username_hint.txt

126 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/10String & Regex Operations/6 Extract Email Username/extract_email_username_solution.txt

215 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/10String & Regex Operations/7Count Words in Comment/comment_wordcount_hint.txt

267 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/10String & Regex Operations/7Count Words in Comment/comment_wordcount_solution.txt

965 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/10String & Regex Operations/8 Find Palindromic Tags/palindromic_tags_hint.txt

154 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/10String & Regex Operations/8 Find Palindromic Tags/palindromic_tags_solution.txt

351 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/11Open Problems/1 Find Start and End of Each range/continuous_login_ranges_hint.txt

305 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/11Open Problems/1 Find Start and End of Each range/continuous_login_ranges_solution.txt

467 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/11Open Problems/2 Customers Who Bought from All Categories/customers_all_categories_hint.txt

298 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/11Open Problems/2 Customers Who Bought from All Categories/customers_all_categories_solution.txt

410 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/1 Candidates for Upskilling Campaign/priority_candidates_hint.txt

241 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/1 Candidates for Upskilling Campaign/priority_candidates_solution.txt

324 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/10 Users With Most Transactions Last Month/users_top_transactions_last_month_hint.txt

259 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/10 Users With Most Transactions Last Month/users_top_transactions_last_month_solution.txt

662 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/11 Multi-City Logins/multi_city_login_hint.txt

137 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/11 Multi-City Logins/multi_city_login_solution.txt

426 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/12 Delivery Time by Day/delivery_time_by_day_grocery_hint.txt

237 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/12 Delivery Time by Day/delivery_time_by_day_grocery_solution.txt

478 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/13 Cart Abandoners/cart_abandoners_hint.txt

306 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/13 Cart Abandoners/cart_abandoners_solution.txt

918 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/14Top Spenders/top_spenders_fashion_hint.txt

197 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/14Top Spenders/top_spenders_fashion_solution.txt

374 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/2 Multiple diagnoses per visit/multiple_diagnoses_hint.txt

97 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/2 Multiple diagnoses per visit/multiple_diagnoses_solution.txt

425 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/3 First-day signups never returning/first_day_only_streaming_users_hint.txt

184 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/3 First-day signups never returning/first_day_only_streaming_users_solution.txt

678 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/4Avg Shipping Delay/avg_shipping_delay_hint.txt

172 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/4Avg Shipping Delay/avg_shipping_delay_solution.txt

436 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/5 Booking to visit delay/avg_booking_delay_by_specialty_hint.txt

198 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/5 Booking to visit delay/avg_booking_delay_by_specialty_solution.txt

576 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/6Conversion Rate per Campaign/conversion_rate_campaign_hint.txt

174 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/6Conversion Rate per Campaign/conversion_rate_campaign_solution.txt

701 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/7New vs Repeat Visitors/new_vs_repeat_visitors_hint.txt

195 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/7New vs Repeat Visitors/new_vs_repeat_visitors_solution.txt

442 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/8Repeat Buyers by Product/repeat_buyers_beautystore_hint.txt

217 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/8Repeat Buyers by Product/repeat_buyers_beautystore_solution.txt

767 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/9 Most Active Hour per App/most_active_hour_per_app_hint.txt

176 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/1Basic Filtering & Aggregations/9 Most Active Hour per App/most_active_hour_per_app_solution.txt

903 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/2Joins & Anti‑Joins/1Customer Names on Orders/customer_names_on_orders_hint.txt

85 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/2Joins & Anti‑Joins/1Customer Names on Orders/customer_names_on_orders_solution.txt

280 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/2Joins & Anti‑Joins/2Fare by Time/fare_by_time_hint.txt

218 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/2Joins & Anti‑Joins/2Fare by Time/fare_by_time_solution.txt

875 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/2Joins & Anti‑Joins/3Grand Slam Counts/grand_slam_counts_hint.txt

137 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/2Joins & Anti‑Joins/3Grand Slam Counts/grand_slam_counts_solution.txt

405 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/2Joins & Anti‑Joins/4Unbooked Room Types/unbooked_room_types_hint.txt

233 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/2Joins & Anti‑Joins/4Unbooked Room Types/unbooked_room_types_solution.txt

590 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/2Joins & Anti‑Joins/5Team-Wise Latest Salesperson/latest_valid_sale_leaderboard_hint.txt

276 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/2Joins & Anti‑Joins/5Team-Wise Latest Salesperson/latest_valid_sale_leaderboard_solution.txt

1.4 kB

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/2Joins & Anti‑Joins/6 Best Movie Discounts/best_movie_discounts_hint.txt

230 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/2Joins & Anti‑Joins/6 Best Movie Discounts/best_movie_discounts_solution.txt

940 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/2Joins & Anti‑Joins/7 First Overlapping Plans/first_overlapping_subscriptions_hint.txt

268 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/2Joins & Anti‑Joins/7 First Overlapping Plans/first_overlapping_subscriptions_solution.txt

881 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/10 7-Day Rolling Avg Visitors/rolling_avg_museum_hint.txt

231 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/10 7-Day Rolling Avg Visitors/rolling_avg_museum_solution.txt

1.1 kB

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/11 Posting Streaks/posting_streaks_hint.txt

320 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/11 Posting Streaks/posting_streaks_solution.txt

2.7 kB

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/12 Salary Raise Tracker/salary_raise_tracker_hint.txt

240 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/12 Salary Raise Tracker/salary_raise_tracker_solution.txt

1.0 kB

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/13 User Watch Gaps & Streaming Behavior/user_watch_gaps_hint.txt

162 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/13 User Watch Gaps & Streaming Behavior/user_watch_gaps_solution.txt

979 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/1Latest Login per User/latest_login_per_user_hint.txt

164 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/1Latest Login per User/latest_login_per_user_solution.txt

407 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/2 2nd bank transaction per user/second_txn_hint.txt

127 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/2 2nd bank transaction per user/second_txn_solution.txt

1.1 kB

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/3 Top Items By Section/top_items_by_section_hint.txt

97 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/3 Top Items By Section/top_items_by_section_solution.txt

531 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/4 Top 2 Products per City/top2_products_city_hint.txt

202 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/4 Top 2 Products per City/top2_products_city_solution.txt

790 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/5 Salary Quartile Buckets/salary_quartile_hint.txt

123 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/5 Salary Quartile Buckets/salary_quartile_solution.txt

250 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/6 Running Total of Sales per Region/running_total_electromax_hint.txt

126 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/6 Running Total of Sales per Region/running_total_electromax_solution.txt

343 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/7Salary Difference Relative/salary_diff_hint.txt

178 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/7Salary Difference Relative/salary_diff_solution.txt

416 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/8 Time to Next Login/time_to_next_login_hint.txt

149 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/8 Time to Next Login/time_to_next_login_solution.txt

377 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/9 Mismatched Movie Rentals/movie_mismatch_hint.txt

287 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/3Window Functions/9 Mismatched Movie Rentals/movie_mismatch_solution.txt

678 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/4Date & Time‑Based Reporting/1Users Registered This Month/users_registered_this_month_hint.txt

132 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/4Date & Time‑Based Reporting/1Users Registered This Month/users_registered_this_month_solution.txt

170 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/4Date & Time‑Based Reporting/2 Kids by Admission Month/admissions_by_month_hint.txt

188 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/4Date & Time‑Based Reporting/2 Kids by Admission Month/admissions_by_month_solution.txt

392 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/4Date & Time‑Based Reporting/3Weekend Vs Weekday Signups/weekend_vs_weekday_hint.txt

209 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/4Date & Time‑Based Reporting/3Weekend Vs Weekday Signups/weekend_vs_weekday_solution.txt

435 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/4Date & Time‑Based Reporting/4Second Book Purchase Timeline/second_book_purchase_hint.txt

156 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/4Date & Time‑Based Reporting/4Second Book Purchase Timeline/second_book_purchase_solution.txt

879 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/4Date & Time‑Based Reporting/5 Time from Signup to Enrollment/signup_to_first_enrollment_hint.txt

192 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/4Date & Time‑Based Reporting/5 Time from Signup to Enrollment/signup_to_first_enrollment_solution.txt

465 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/4Date & Time‑Based Reporting/6 Week-over-Week Metro App Footfall/metro_footfall_hint.txt

396 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/4Date & Time‑Based Reporting/6 Week-over-Week Metro App Footfall/metro_footfall_solution.txt

780 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/4Date & Time‑Based Reporting/7Doctor Visit Gaps/visit_gaps_hint.txt

150 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/4Date & Time‑Based Reporting/7Doctor Visit Gaps/visit_gaps_solution.txt

736 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/4Date & Time‑Based Reporting/8Support Response/support_delay_hint.txt

121 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/4Date & Time‑Based Reporting/8Support Response/support_delay_solution.txt

344 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/10 Consistently Shortlisted Candidates/shortlisted_candidates_hint.txt

278 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/10 Consistently Shortlisted Candidates/shortlisted_candidates_solution.txt

767 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/11Buyer Segments (RFM)/buyer_segments_hint.txt

373 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/11Buyer Segments (RFM)/buyer_segments_solution.txt

1.2 kB

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/1Top Product by Sales/top_product_by_sales_hint.txt

189 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/1Top Product by Sales/top_product_by_sales_solution.txt

454 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/2 Most recent doctor's appointment/most_recent_appointments_hint.txt

0 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/2 Most recent doctor's appointment/most_recent_appointments_solution.txt

0 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/3 Only Buys Discounted Products/deal_hunter_customers_hint.txt

156 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/3 Only Buys Discounted Products/deal_hunter_customers_solution.txt

1.5 kB

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/4Customer Return Rate/customer_return_rate_hint.txt

194 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/4Customer Return Rate/customer_return_rate_solution.txt

822 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/5 Influencer earnings ≥ $1000/influencer_earnings_hint.txt

143 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/5 Influencer earnings ≥ $1000/influencer_earnings_solution.txt

326 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/6Manual Recovery/manual_recovery_hint.txt

203 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/6Manual Recovery/manual_recovery_solution.txt

359 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/7Leads Converted Fast/leads_converted_fast_hint.txt

381 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/7Leads Converted Fast/leads_converted_fast_solution.txt

921 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/8Salary Disparity in Grade/salary_disparity_hint.txt

235 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/8Salary Disparity in Grade/salary_disparity_solution.txt

640 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/9 Frequent Ride Cancellers/frequent_ride_cancellers_hint.txt

368 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/5Subqueries & CTEs/9 Frequent Ride Cancellers/frequent_ride_cancellers_solution.txt

773 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/10Lowest Rated Price by Category/lowest_rated_price_by_category_hint.txt

210 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/10Lowest Rated Price by Category/lowest_rated_price_by_category_solution.txt

539 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/11Top 10% Sellers Avg Order/top_10_percent_sellers_avg_hint.txt

155 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/11Top 10% Sellers Avg Order/top_10_percent_sellers_avg_solution.txt

273 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/12 Top Tags per Product (GROUP_CONCAT)/group_concat_tags_hint.txt

99 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/12 Top Tags per Product (GROUP_CONCAT)/group_concat_tags_solution.txt

147 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/13 Shared Orders/shared_orders_with_join_hint.txt

231 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/13 Shared Orders/shared_orders_with_join_solution.txt

518 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/14Blood Sugar Drift & Risk Outlook/blood_sugar_drift_hint.txt

572 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/14Blood Sugar Drift & Risk Outlook/blood_sugar_drift_solution.txt

1.2 kB

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/1Gender Counts by CASE/gender_case_distribution_hint.txt

165 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/1Gender Counts by CASE/gender_case_distribution_solution.txt

559 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/2NULL Email % per Domain/null_email_percent_by_domain_hint.txt

103 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/2NULL Email % per Domain/null_email_percent_by_domain_solution.txt

1020 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/3Cancelled% by Category/cancelled_percent_by_category_hint.txt

174 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/3Cancelled% by Category/cancelled_percent_by_category_solution.txt

768 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/4 Return Rate by Apparel Brand/return_rate_by_brand_hint.txt

219 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/4 Return Rate by Apparel Brand/return_rate_by_brand_solution.txt

516 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/5Low Mileage Cars/low_mileage_outliers_hint.txt

225 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/5Low Mileage Cars/low_mileage_outliers_solution.txt

504 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/6Late Shipment % by Courier/late_shipment_pct_by_courier_hint.txt

175 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/6Late Shipment % by Courier/late_shipment_pct_by_courier_solution.txt

306 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/7Raised vs Resolved Ticket Ratio/ticket_resolution_ratio_hint.txt

159 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/7Raised vs Resolved Ticket Ratio/ticket_resolution_ratio_solution.txt

481 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/8Most Used Coupon Code/most_used_coupon_code_hint.txt

144 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/8Most Used Coupon Code/most_used_coupon_code_solution.txt

436 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/9Most Frequent Actor Pair/frequent_actor_pairs_hint.txt

304 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/6Advanced Aggregations/9Most Frequent Actor Pair/frequent_actor_pairs_solution.txt

664 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/7Recursive CTEs & Hierarchies/1Top Manager for Each Employee/top_manager_hint.txt

220 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/7Recursive CTEs & Hierarchies/1Top Manager for Each Employee/top_manager_solution.txt

628 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/7Recursive CTEs & Hierarchies/2Management Reporting Tree/management_tree_hint.txt

176 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/7Recursive CTEs & Hierarchies/2Management Reporting Tree/management_tree_solution.txt

568 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/7Recursive CTEs & Hierarchies/3 Leaf Employees (No Reportees)/leaf_employees_hint.txt

133 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/7Recursive CTEs & Hierarchies/3 Leaf Employees (No Reportees)/leaf_employees_solution.txt

276 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/7Recursive CTEs & Hierarchies/4 Employee Hierarchy Depth/employee_depth_hint.txt

182 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/7Recursive CTEs & Hierarchies/4 Employee Hierarchy Depth/employee_depth_solution.txt

661 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/7Recursive CTEs & Hierarchies/5Org‑Chart Salary Roll‑up/org_chart_rollup_hint.txt

207 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/7Recursive CTEs & Hierarchies/5Org‑Chart Salary Roll‑up/org_chart_rollup_solution.txt

697 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/8Set Operations(UNION)/1Buyers OR Sellers/buyers_or_sellers_hint.txt

150 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/8Set Operations(UNION)/1Buyers OR Sellers/buyers_or_sellers_solution.txt

313 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/8Set Operations(UNION)/2 Freelancers with Dual Roles/freelancers_with_dual_roles_hint.txt

275 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/8Set Operations(UNION)/2 Freelancers with Dual Roles/freelancers_with_dual_roles_solution.txt

947 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/8Set Operations(UNION)/3 Risky Trades/risky_trade_users_hint.txt

278 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/8Set Operations(UNION)/3 Risky Trades/risky_trade_users_solution.txt

1.1 kB

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/8Set Operations(UNION)/4 Cross-Platform Travelers/cross_platform_travelers_hint.txt

192 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/8Set Operations(UNION)/4 Cross-Platform Travelers/cross_platform_travelers_solution.txt

1.1 kB

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/8Set Operations(UNION)/5 Bundle-Only Buyers/bundle_only_buyers_hint.txt

202 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/8Set Operations(UNION)/5 Bundle-Only Buyers/bundle_only_buyers_solution.txt

1.2 kB

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/8Set Operations(UNION)/6 Job Seekers Incomplete Action/job_seekers_incomplete_action_hint.txt

272 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/8Set Operations(UNION)/6 Job Seekers Incomplete Action/job_seekers_incomplete_action_solution.txt

930 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/9PIVOT & UNPIVOT/1 Count Orders by Status/orders_status_pivot_hint.txt

94 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/9PIVOT & UNPIVOT/1 Count Orders by Status/orders_status_pivot_solution.txt

379 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/9PIVOT & UNPIVOT/2 Monthly Attendance Unpivot/monthly_attendance_unpivot_hint.txt

148 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/9PIVOT & UNPIVOT/2 Monthly Attendance Unpivot/monthly_attendance_unpivot_solution.txt

375 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/9PIVOT & UNPIVOT/3 Streams by day and Genre/streams_by_weekday_genre_hint.txt

164 B

~Get Your Files Here !/1 - Introduction/SQL Interview Kit_v0.1/9PIVOT & UNPIVOT/3 Streams by day and Genre/streams_by_weekday_genre_solution.txt

588 B

~Get Your Files Here !/10 - Set Operations (UNION)/1 - Bundle-Only Buyers - Medium-Hard.html

2.6 kB

~Get Your Files Here !/10 - Set Operations (UNION)/1 - Buyers or Sellers- Easy.html

3.0 kB

~Get Your Files Here !/10 - Set Operations (UNION)/1 - Cross-Platform Travelers - Hard.html

3.3 kB

~Get Your Files Here !/10 - Set Operations (UNION)/1 - Freelancers with Dual Roles - Medium.html

3.0 kB

~Get Your Files Here !/10 - Set Operations (UNION)/1 - Job Seekers Incomplete Action - Hard.html

2.6 kB

~Get Your Files Here !/10 - Set Operations (UNION)/1 - Risky Trades - Medium.html

3.3 kB

~Get Your Files Here !/11 - PIVOT & UNPIVOT/1 - Count Orders by Status (Pivot) – Medium.html

2.0 kB

~Get Your Files Here !/11 - PIVOT & UNPIVOT/1 - Monthly Attendance Unpivot – Medium.html

2.3 kB

~Get Your Files Here !/11 - PIVOT & UNPIVOT/1 - Streams by day and Genre – Medium.html

3.1 kB

~Get Your Files Here !/12 - String & Regex Operations/1 - Extract Email Username - Medium.html

2.0 kB

~Get Your Files Here !/12 - String & Regex Operations/1 - Find Palindrome Strings - Medium.html

1.9 kB

~Get Your Files Here !/12 - String & Regex Operations/1 - Items Ordered per User - Easy.html

2.2 kB

~Get Your Files Here !/12 - String & Regex Operations/1 - Normalize Phone Numbers - Medium.html

1.9 kB

~Get Your Files Here !/12 - String & Regex Operations/1 - Replace Symbols in Feedback - Medium.html

2.6 kB

~Get Your Files Here !/12 - String & Regex Operations/1 - Split Customer Name - Easy.html

2.1 kB

~Get Your Files Here !/12 - String & Regex Operations/1 - Trim & Normalize Emails - Easy.html

1.8 kB

~Get Your Files Here !/12 - String & Regex Operations/1 - Word Count in Comments - Medium.html

2.3 kB

~Get Your Files Here !/13 - Open Problems/1 - Customers Who Bought from All Categories.html

2.3 kB

~Get Your Files Here !/13 - Open Problems/1 - Start and End of Continuous Range.html

2.2 kB

~Get Your Files Here !/14 - Thank You !!/1 -Thank you & Best Wishes.mp4

19 MB

~Get Your Files Here !/2 - Warm‑Up Challenges/1 - Active Admin Users - Easy.html

2.4 kB

~Get Your Files Here !/2 - Warm‑Up Challenges/1 -Solution Walkthrough.mp4

20 MB

~Get Your Files Here !/2 - Warm‑Up Challenges/2 - Spend per Customer – Easy.html

2.0 kB

~Get Your Files Here !/2 - Warm‑Up Challenges/2 -Solution Walkthrough.mp4

18 MB

~Get Your Files Here !/2 - Warm‑Up Challenges/3 - Payment Method Breakdown – Easy.html

2.6 kB

~Get Your Files Here !/2 - Warm‑Up Challenges/3 - Viewers and Plans – Easy.html

3.0 kB

~Get Your Files Here !/2 - Warm‑Up Challenges/3 -Solution Walkthrough.mp4

25 MB

~Get Your Files Here !/2 - Warm‑Up Challenges/4 - Users Who Never Logged In – Easy.html

2.7 kB

~Get Your Files Here !/2 - Warm‑Up Challenges/4 -Solution Walkthrough.mp4

41 MB

~Get Your Files Here !/2 - Warm‑Up Challenges/5 - Top 3 Articles per User – Medium.html

3.6 kB

~Get Your Files Here !/2 - Warm‑Up Challenges/5 -Solution Walkthrough.mp4

57 MB

~Get Your Files Here !/2 - Warm‑Up Challenges/6 - New vs Delayed Gym Members– Medium.html

3.6 kB

~Get Your Files Here !/2 - Warm‑Up Challenges/6 -Solution Walkthrough.mp4

103 MB

~Get Your Files Here !/2 - Warm‑Up Challenges/7 - All Creators and Moderators – Easy.html

2.5 kB

~Get Your Files Here !/2 - Warm‑Up Challenges/7 -Solution Walkthrough.mp4

31 MB

~Get Your Files Here !/2 - Warm‑Up Challenges/8 - IT Ticket Status Count – Medium.html

2.4 kB

~Get Your Files Here !/2 - Warm‑Up Challenges/8 -Solution Walkthrough.mp4

44 MB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/1 - Candidates for Upskilling Campaign - Easy.html

3.0 kB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/1 -Solution Walkthrough.mp4

44 MB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/10 - Cart Abandoners - Medium.html

2.9 kB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/10 -Solution Walkthrough.mp4

66 MB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/11 - Top Spenders - Easy.html

2.2 kB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/2 - First-day Signups Users Never Returning - Medium.html

3.0 kB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/2 - Multiple Diagnoses per Visit– Easy.html

1.8 kB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/2 -Solution Walkthrough.mp4

75 MB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/3 - Avg Shipping Delay - Medium.html

3.0 kB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/3 -Solution Walkthrough.mp4

43 MB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/4 - Booking to Visit Delay - Medium.html

3.0 kB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/4 - Campaign Conversion Rate - Medium.html

2.3 kB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/4 -Solution Walkthrough.mp4

54 MB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/5 - New vs Repeat Visitors - Medium.html

2.7 kB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/5 -Solution Walkthrough.mp4

54 MB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/6 - Most Active Hour per App - Medium.html

2.3 kB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/6 - Repeat Buyers by Product - Medium.html

2.5 kB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/6 -Solution Walkthrough.mp4

69 MB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/7 - Users With Most Transactions - Medium.html

2.1 kB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/7 -Solution Walkthrough.mp4

56 MB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/8 - Multi-City Logins - Easy.html

2.4 kB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/8 -Solution Walkthrough.mp4

32 MB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/9 - Delivery Time by Day - Medium.html

2.2 kB

~Get Your Files Here !/3 - Basic Filtering & Aggregations/9 -Solution Walkthrough.mp4

52 MB

~Get Your Files Here !/4 - Joins & Anti‑Joins/1 - Customer Names on Orders – Easy.html

2.4 kB

~Get Your Files Here !/4 - Joins & Anti‑Joins/1 - Fare by Time– Medium.html

3.3 kB

~Get Your Files Here !/4 - Joins & Anti‑Joins/1 -Solution Walkthrough.mp4

97 MB

~Get Your Files Here !/4 - Joins & Anti‑Joins/2 - Grand Slam Counts (incl zero) – Easy.html

3.0 kB

~Get Your Files Here !/4 - Joins & Anti‑Joins/2 - Unbooked Room Types – Medium.html

3.1 kB

~Get Your Files Here !/4 - Joins & Anti‑Joins/2 -Solution Walkthrough.mp4

55 MB

~Get Your Files Here !/4 - Joins & Anti‑Joins/3 - Latest Valid Sale Per team – Medium.html

3.7 kB

~Get Your Files Here !/4 - Joins & Anti‑Joins/3 -Solution Walkthrough.mp4

104 MB

~Get Your Files Here !/4 - Joins & Anti‑Joins/4 - Best Movie Discounts - Medium.html

2.2 kB

~Get Your Files Here !/4 - Joins & Anti‑Joins/4 -Solution Walkthrough.mp4

86 MB

~Get Your Files Here !/4 - Joins & Anti‑Joins/5 - First Overlapping Plans - Hard.html

2.4 kB

~Get Your Files Here !/4 - Joins & Anti‑Joins/5 -Solution Walkthrough.mp4

83 MB

~Get Your Files Here !/5 - Window Functions/1 - 2nd Transaction Date per Customer – Medium.html

2.1 kB

~Get Your Files Here !/5 - Window Functions/1 - Latest Login per User – Easy.html

1.8 kB

~Get Your Files Here !/5 - Window Functions/1 - Top Items by Section – Medium.html

2.8 kB

~Get Your Files Here !/5 - Window Functions/1 -Solution Walkthrough.mp4

32 MB

~Get Your Files Here !/5 - Window Functions/2 - Salary Quartile Buckets - Medium.html

2.8 kB

~Get Your Files Here !/5 - Window Functions/2 - Top 2 Products per City - Medium.html

2.9 kB

~Get Your Files Here !/5 - Window Functions/2 -Solution Walkthrough.mp4

30 MB

~Get Your Files Here !/5 - Window Functions/3 - Running Total of Sales(Cumulative) per Region - Medium.html

2.6 kB

~Get Your Files Here !/5 - Window Functions/3 -Solution Walkthrough.mp4

28 MB

~Get Your Files Here !/5 - Window Functions/4 - Salary Difference Relative – Medium.html

2.6 kB

~Get Your Files Here !/5 - Window Functions/4 -Solution Walkthrough.mp4

47 MB

~Get Your Files Here !/5 - Window Functions/5 - Time to Next Login - Medium.html

2.4 kB

~Get Your Files Here !/5 - Window Functions/5 -Solution Walkthrough.mp4

35 MB

~Get Your Files Here !/5 - Window Functions/6 - Mismatched Movie Rentals - Medium.html

2.9 kB

~Get Your Files Here !/5 - Window Functions/6 -Solution Walkthrough.mp4

53 MB

~Get Your Files Here !/5 - Window Functions/7 - 7-Day Rolling Avg Visitors – Hard.html

2.7 kB

~Get Your Files Here !/5 - Window Functions/7 -Solution Walkthrough.mp4

53 MB

~Get Your Files Here !/5 - Window Functions/8 - Posting Streaks – Medium-Hard.html

2.7 kB

~Get Your Files Here !/5 - Window Functions/8 -Solution Walkthrough.mp4

73 MB

~Get Your Files Here !/5 - Window Functions/9 - Salary Raise Tracker - Hard.html

3.3 kB

~Get Your Files Here !/5 - Window Functions/9 - User Watch Gaps & Streaming Behavior - Medium–Hard.html

3.5 kB

~Get Your Files Here !/5 - Window Functions/9 -Solution Walkthrough.mp4

61 MB

~Get Your Files Here !/6 - Date & Time‑Based Reporting/1 - Users Registered This Month – Easy.html

1.7 kB

~Get Your Files Here !/6 - Date & Time‑Based Reporting/1 -Solution Walkthrough.mp4

28 MB

~Get Your Files Here !/6 - Date & Time‑Based Reporting/2 - Kids by Admission Month – Easy.html

2.0 kB

~Get Your Files Here !/6 - Date & Time‑Based Reporting/2 -Solution Walkthrough.mp4

22 MB

~Get Your Files Here !/6 - Date & Time‑Based Reporting/3 - Weekend Vs Weekday Signups – Easy.html

2.6 kB

~Get Your Files Here !/6 - Date & Time‑Based Reporting/4 - Second Book Purchase Timeline – Medium.html

2.0 kB

~Get Your Files Here !/6 - Date & Time‑Based Reporting/4 -Solution Walkthrough.mp4

55 MB

~Get Your Files Here !/6 - Date & Time‑Based Reporting/5 - Doctor Visit Gaps (180d) – Medium.html

2.2 kB

~Get Your Files Here !/6 - Date & Time‑Based Reporting/5 - Time from Signup to Enrollment – Medium.html

3.5 kB

~Get Your Files Here !/6 - Date & Time‑Based Reporting/5 - Week-over-Week Metro App Footfall – Medium.html

2.7 kB

~Get Your Files Here !/6 - Date & Time‑Based Reporting/5 -Solution Walkthrough.mp4

40 MB

~Get Your Files Here !/6 - Date & Time‑Based Reporting/6 - Support Response 24 hrs – Easy.html

2.9 kB

~Get Your Files Here !/6 - Date & Time‑Based Reporting/6 -Solution Walkthrough.mp4

31 MB

~Get Your Files Here !/7 - Subqueries & CTEs/1 - Most Recent Doctor's Appointment – Easy.html

2.4 kB

~Get Your Files Here !/7 - Subqueries & CTEs/1 - Top Product by Sales – Easy.html

1.9 kB

~Get Your Files Here !/7 - Subqueries & CTEs/1 -Solution Walkthrough.mp4

23 MB

~Get Your Files Here !/7 - Subqueries & CTEs/10 - Recency, Frequency, Monetary(Buyer Segment)- Medium-Hard.html

3.9 kB

~Get Your Files Here !/7 - Subqueries & CTEs/10 -Solution Walkthrough.mp4

112 MB

~Get Your Files Here !/7 - Subqueries & CTEs/2 - Deal Hunter Customers - Medium.html

2.7 kB

~Get Your Files Here !/7 - Subqueries & CTEs/2 -Solution Walkthrough.mp4

49 MB

~Get Your Files Here !/7 - Subqueries & CTEs/3 - Customer Return Rate – Medium.html

2.2 kB

~Get Your Files Here !/7 - Subqueries & CTEs/3 -Solution Walkthrough.mp4

54 MB

~Get Your Files Here !/7 - Subqueries & CTEs/4 - Influencer earnings ≥ $1000 – Easy.html

2.7 kB

~Get Your Files Here !/7 - Subqueries & CTEs/4 -Solution Walkthrough.mp4

34 MB

~Get Your Files Here !/7 - Subqueries & CTEs/5 - Manual Recovery – Medium.html

2.6 kB

~Get Your Files Here !/7 - Subqueries & CTEs/5 -Solution Walkthrough.mp4

44 MB

~Get Your Files Here !/7 - Subqueries & CTEs/6 - Leads Converted Fast– Medium.html

2.9 kB

~Get Your Files Here !/7 - Subqueries & CTEs/6 -Solution Walkthrough.mp4

55 MB

~Get Your Files Here !/7 - Subqueries & CTEs/7 - Salary Disparity in Grade – Medium-Hard.html

2.4 kB

~Get Your Files Here !/7 - Subqueries & CTEs/7 -Solution Walkthrough.mp4

47 MB

~Get Your Files Here !/7 - Subqueries & CTEs/8 - Frequent Ride Cancellers - Medium-Hard.html

3.4 kB

~Get Your Files Here !/7 - Subqueries & CTEs/8 -Solution Walkthrough.mp4

61 MB

~Get Your Files Here !/7 - Subqueries & CTEs/9 - Consistently Shortlisted Candidates - Medium-Hard.html

4.1 kB

~Get Your Files Here !/7 - Subqueries & CTEs/9 -Solution Walkthrough.mp4

56 MB

~Get Your Files Here !/8 - Advanced Aggregations/1 - Blood Sugar Drift & Risk Outlook – Medium.html

3.6 kB

~Get Your Files Here !/8 - Advanced Aggregations/1 - Cancelled% by Category – Easy.html

3.4 kB

~Get Your Files Here !/8 - Advanced Aggregations/1 - Gender Counts by CASE – Easy.html

2.4 kB

~Get Your Files Here !/8 - Advanced Aggregations/1 - Late Shipment % by Courier – Medium.html

2.1 kB

~Get Your Files Here !/8 - Advanced Aggregations/1 - Low Mileage Cars – Medium.html

3.0 kB

~Get Your Files Here !/8 - Advanced Aggregations/1 - Lowest Rated Price by Category – Medium.html

2.6 kB

~Get Your Files Here !/8 - Advanced Aggregations/1 - Most Frequent Actor Pair - Medium-Hard.html

2.8 kB

~Get Your Files Here !/8 - Advanced Aggregations/1 - Most Used Coupon Code – Easy.html

2.0 kB

~Get Your Files Here !/8 - Advanced Aggregations/1 - NULL Email % per Domain – Easy.html

2.8 kB

~Get Your Files Here !/8 - Advanced Aggregations/1 - Raised vs Resolved Ticket Ratio – Medium.html

1.7 kB

~Get Your Files Here !/8 - Advanced Aggregations/1 - Return Rate by Apparel Brand – Medium.html

2.8 kB

~Get Your Files Here !/8 - Advanced Aggregations/1 - Shared Orders - Medium-Hard.html

2.6 kB

~Get Your Files Here !/8 - Advanced Aggregations/1 - Top 10% Sellers Avg Order – Medium.html

1.9 kB

~Get Your Files Here !/8 - Advanced Aggregations/1 - Top Tags per Product - Medium.html

1.8 kB

~Get Your Files Here !/9 - Recursive CTEs & Hierarchies/1 - Employee Hierarchy Depth - Medium-Hard.html

1.8 kB

~Get Your Files Here !/9 - Recursive CTEs & Hierarchies/1 - Leaf Employees (No Reportees) - Easy.html

1.5 kB

~Get Your Files Here !/9 - Recursive CTEs & Hierarchies/1 - Management Reporting Tree – Medium.html

2.2 kB

~Get Your Files Here !/9 - Recursive CTEs & Hierarchies/1 - Org‑Chart Salary Roll‑up – Extreme.html

2.5 kB

~Get Your Files Here !/9 - Recursive CTEs & Hierarchies/1 - Top Manager for Each Employee – Medium.html

2.9 kB

~Get Your Files Here !/Bonus Resources.txt

70 B