Skip to content

Latest commit

 

History

History

interview-query-solutions

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 
 
 




Description

The compiled solutions encompass all SQL questions, ranging from Medium to Hard (excluding Easy), on Interview Query. These solutions were executed on the integrated PostgreSQL environment.

Solution Table

In the below tables, the columns indicate the following attributes related to the challenge:

  • ID : Identity column for individual challenge

  • Challenge : Link to the SQL challenge hosted on Interview Query

  • Solution Script : Link to the solution SQL script hosted in this repository.

Table Of Contents

Difficulty : Hard 🔴

ID Question Solution
1 First Touch Attribution Solution
2 Rolling Bank Transactions Solution
3 Subscription Overlap Solution
4 Paired Products Solution
5 Activity Conversion Solution
6 Swipe Precision Solution
7 Payments Received Solution
8 Cumulative Distribution Solution
9 Page Recommendations Solution
10 Total Time in Flight Solution
11 Sequentially Fill in Integers Solution
12 New Notification Solution
13 John's New Best Friend Solution
14 Career Jumping Solution
15 Flight Records Solution
16 Liker's Likers Solution
17 CTR by Age Solution
18 Best Performing Advertisers Solution
19 Annual Retention Solution
20 Search CTR Solution
21 Fraudulent Upvotes Solution
22 Notification Deliveries Solution
23 Subscription Retention Solution
24 180 Day Job Postings Solution
25 Cumulative Reset Solution
26 Notification Type Conversion Solution
27 Second Longest Flight Solution
28 User System Response Times Solution

Difficulty : Medium 🟡

ID Question Solution
1 Top 5 Turnover Risk Solution
2 Average Commute Time Solution
3 Completed Shipments Solution
4 Upsell Transactions Solution
5 Generate Shopping List from Recipes Solution
6 Slacking Employees Salaries Solution
7 Order Addresses Solution
8 Closest SAT Scores Solution
9 Monthly Customer Report Solution
10 Exam Scores Solution
11 Duplicate Rows Solution
12 Identifying User Sessions Solution
13 Random Weighted Driver Solution
14 Employee Salaries Solution
15 Top Three Salaries Solution
16 Search Ratings Solution
17 International e-Commerce Warehouse Solution
18 Employee Salaries (ETL Error) Solution
19 Random SQL Sample Solution
20 Comments Histogram Solution
21 Departmental Spend By Quarter Solution
22 Percentage of Revenue by Year Solution
23 Interpolating Missing Temperatures Solution
24 Categorize Sales Solution
25 Closed Accounts Solution
26 Released Patients Solution
27 Total Conversation Threads Solution
28 HR Salary Reporting Solution
29 Customer Orders Solution
30 Third Purchase Solution
31 Lowest Paid Solution
32 ATM Robbery Solution
33 Unique Work Days Solution
34 Rolling Average Steps Solution
35 Top 3 Users Solution
36 Avg Friend Requests By Age Group Solution
37 Crossing Bridges Solution
38 Department Expenses Solution
39 Attribution Rules Solution
40 t Value via SQL Solution
41 Fast Food Database Solution
42 Cumulative Sales Since Last Restocking Solution
43 Ad Comments Solution
44 Longest Streak Users Solution
45 Project Pairs Solution
46 Third Unique Song Solution
47 Employees Before Managers Solution
48 SMS Confirmations Solution
49 Transactions in the Last 5 Days Solution
50 Employee Project Budgets Solution
51 Feed Impression Solution
52 7 Day Streak Solution
53 Monthly Product Sales Solution
54 Sample Time Series Solution
55 Comment Upvotes Solution
56 Free Seats Solution
57 Cumulative Sales By Product Solution
58 Repeat Job Postings Solution
59 Liked Pages Solution
60 Search Ranking Solution
61 Post Success Solution
62 Liked and Commented Solution
63 Conversations Distribution Solution
64 Month Over Month Solution
65 Above Average Product Prices Solution
66 Size of Joins Solution
67 Over-Budget Projects Solution
68 Friend Request Acceptance Rate Solution
69 Weighted Average Campaigns Solution
70 Average Unique Counts Solution
71 Branch Sales Pivot Solution
72 Weighted Average With Missing Dates Solution
73 Weighted Average Sales Solution
74 Median Household Income Solution
75 User Experience Percentage Solution

References

Contributing

Contributions are always welcome !!

If you would like to contribute to the project, please fork the repository and make a pull request.

Support

If you have any doubts, queries or, suggestions then, please connect with me on LinkedIn.

Do ⭐ the repository, if it inspired you, gave you ideas of your own or helped you in any way !!