Description

The compiled solutions encompass all SQL questions, ranging from Easy to Hard, on DataLemur. These solutions were executed on the integrated PostgreSQL environment.

NOTE : Referral code

Get access to bonus content and exclusive prizes for BOTH of us by signing-up, followed by email verification using this referral code link.

Solution Table

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

• ID : Identity column for individual challenge

• Challenge : Link to the SQL challenge hosted on DataLemur

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

• Company : Name of the company where the questions were posed during the interview.

Table Of Contents

• Easy

• Medium

• Hard

Difficulty : Easy 🟢 (35/35)

ID	Challenge	Solutions	Company
01	Histogram of Tweets	Solution	X
02	Data Science Skills	Solution	Linkedin
03	Page With No Likes	Solution	Meta
04	Unfinished Parts	Solution	Tesla
05	Laptop vs Mobile Viewership	Solution	New York Times
06	Average Post Hiatus (Part 1)	Solution	Meta
07	Teams Power Users	Solution	Microsoft
08	Duplicate Job Listings	Solution	Linkedin
09	Cities With Completed Trades	Solution	Robinhood
10	Average Review Ratings	Solution	Amazon
11	Final Account Balance	Solution	Paypal
12	App Clickthrough Rate (CTR)	Solution	Meta
13	Second Day Confirmation	Solution	Tiktok
14	Cards Issued Difference	Solution	JP Morgan Chase
15	Compressed Mean	Solution	Alibaba
16	Pharmacy Analytics (Part 1)	Solution	CVS Health
17	Pharmacy Analytics (Part 2)	Solution	CVS Health
18	Pharmacy Analytics (Part 3)	Solution	CVS Health
19	Apple Pay Volume	Solution	Visa
20	Subject Matter Experts	Solution	Accenture
21	LinkedIn Power Creators (Part 1)	Solution	Linkedin
22	Highest Number of Products	Solution	Ebay
23	Spare Server Capacity	Solution	Microsoft
24	Top Rated Businesses	Solution	Yelp
25	Ad Campaign ROAS	Solution	Google
26	Who Made Quota?	Solution	Oracle
27 *	Average Deal Size (Part 1)	Solution	Salesforce
28 *	Patient Support Analysis (Part 1)	Solution	United Health
29	Histogram of Unique Queries	Solution	IBM
30 *	Trade In Payouts	Solution	Apple
31 *	QuickBooks vs TurboTax	Solution	Intuit
32 *	Most Expensive Purchase	Solution	Amazon
33 *	Product Line Revenue	Solution	NVIDIA
34 *	Webinar Popularity	Solution	Snowflake
35	Well Paid Employees	Solution	FAANG

Difficulty : Medium 🟡 (42/42)

ID	Challenge	Solutions	Company
01	User's Third Transaction	Solution	Uber
02	Sending vs. Opening Snaps	Solution	Snapchat
03	Tweets' Rolling Averages	Solution	X
04	Highest-Grossing Items	Solution	Amazon
05	Top 5 Artists	Solution	Spotify
06	Signup Activation Rate	Solution	TikTok
07	Fill Missing Client Data	Solution	Accenture
08	Spotify Streaming History	Solution	Spotify
09	Frequently Purchased Pairs	Solution	Walmart
10	Supercloud Customer	Solution	Microsoft
11	Odd and Even Measurements	Solution	Google
12	Histogram of Users and Purchases	Solution	Walmart
13	Compressed Mode	Solution	Alibaba
14	Card Launch Success	Solution	JP Morgan Chase
15	International Call Percentage	Solution	Verizon
16	LinkedIn Power Creators (Part 2)	Solution	Linkedin
17	Unique Money Transfer Relationships	Solution	Paypal
18	User Session Activity	Solution	X
19	First Transaction	Solution	Etsy
20	Photoshop Revenue Analysis	Solution	Adobe
21	Consulting Bench Time	Solution	Google
22	Cumulative Purchases by Product Type	Solution	Amazon
23	Invalid Search Results	Solution	Google
24	Repeat Purchases on Multiple Days	Solution	Stitch Fix
25	Compensation Outliers	Solution	Accenture
26	Google Maps Flagged UGC	Solution	Google
27 *	Best-Selling Product	Solution	Amazon
28 *	NYC Area Code	Solution	Verizon
29 *	Mean, Median, Mode	Solution	Microsoft
30 *	Pharmacy Analytics (Part 4)	Solution	CVS Health
31 *	Booking Referral Source	Solution	Airbnb
32 *	User Shopping Sprees	Solution	Amazon
33 *	2nd Ride Delay	Solution	Uber
34 *	Email Table Transformation	Solution	Meta
35 *	Sales Team Compensation	Solution	Oracle
36 *	Average Deal Size (Part 2)	Solution	Salesforce
37	Patient Support Analysis (Part 2)	Solution	United Health
38	FAANG Stock Min-Max (Part 1)	Solution	Bloomberg
39	FAANG Stock Inter-Month Change (Part 2)	Solution	Bloomberg
40	Top Three Salaries	Solution	FAANG
41	Second Highest Salary	Solution	FAANG
42	Swapped Food Delivery	Solution	Zomato

Difficulty : Hard 🔴 (28/28)

ID	Challenge	Solutions	Compaany
01	Active User Retention	Solution	Meta
02	Y-on-Y Growth Rate	Solution	Wayfair
03	Maximize Prime Item Inventory	Solution	Amazon
04	Median Google Search Frequency	Solution	Google
05	Advertiser Status	Solution	Meta
06	3-Topping Pizzas	Solution	McKinsey
07 *	Same Week Purchases	Solution	Etsy
08	Repeated Payments	Solution	Stripe
09	Server Utilization Time	Solution	Amazon
10 *	Monthly Merchant Balance	Solution	Visa
11 *	Bad Delivery Rate	Solution	DoorDash
12 *	Event Friends Recommendation	Solution	Meta
13 *	User Concurrent Sessions	Solution	Pinterest
14 *	Follow-Up Airpod Percentage	Solution	Apple
15 *	3-Day Rolling Earnings	Solution	Stripe
16 *	Uniquely Staffed Consultants	Solution	Accenture
17 *	Marketing Touch Streak	Solution	Snowflake
18 *	Consecutive Filing Years	Solution	Intuit
19 *	Compressed Median	Solution	Alibaba
20 *	Average Vacant Days	Solution	Airbnb
21 *	Same Week Purchases	Solution	Etsy
22 *	Page Recommendation	Solution	Meta
23 *	Reactivated Users	Solution	Meta
24 *	Senior Managers	Solution	Google
25 *	Matching Rental Amenities	Solution	Airbnb
26 *	Weekly Churn Rates	Solution	Meta
27	FAANG Stock Identify Underperforming Stocks	Solution	Bloomberg
28	Department vs. Company Salary	Solution	FAANG

References

• Instant SQL Formatter

• Github

Contributing

Contributions are always welcome !!

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

Support

Get access to bonus content and exclusive prizes for both of us by signing-up, followed by email verification using this referral code link

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 !!