SQL Join Interview Questions

Master the world of data! Dive into SQL & Python interview questions and get ready for your SQL interview!

affirm afterpay airbnb amazon apple doordash dropbox ebay facebook google linkedin lyft mobile netflix robinhood roblox snap spotify tiktok twitter uber visa walmart

Chapter 3: Multi-Table

ID	Title	Level	FTPR	Lecture
36	Actors from film 'AFRICAN EGG'	easy	32%	3.1
37	Most popular movie category	easy	15%	3.1
38	Most popular movie category (name and id)	medium	19%	3.1
39	Most productive actor with inner join	easy	22%	3.1
40	Top 2 most rented movie in June 2020	medium	14%	3.1
41	Productive actors vs less-productive actors	hard	7%	3.2
42	Films that are in stock vs not in stock	medium	12%	3.2
43	Customers who rented vs. those who did not	medium	8%	3.2
44	In-demand vs not-in-demand movies	medium	6%	3.2
45	Movie inventory optimization	hard	9%	3.2
46	Actors and customers whose last name starts with 'A'	easy	31%	3.3
47	Actors and customers whose first names end in 'D'.	easy	40%	3.3
48	Movie and TV actors	easy	38%	3.1
49	Top 3 money making movie categories	medium	18%	3.1
50	Top 5 cities for movie rentals	easy	22%	3.1
51	Movie only actor	easy	37%	3.2
52	Movies cast by movie only actors	easy	11%	3.2
53	Movie groups by rental income	hard	11%	3.2
54	Customer groups by movie rental spend	medium	20%	3.2
55	Busy days and slow days	medium	10%	3.2
56	Total number of actors	easy	30%	3.2
57	Total number of actors (with UNION)	easy	37%	3.3
87	Top song in the US and UK spotify	medium	9%	3.3
91	same day friend request acceptance rate spotify	easy	13%	3.1
94	Top 3 products vs. bottom 3 products amazon	medium	7%	3.3
99	Page recommendation facebook	medium	13%	3.1
100	Advertiser ROI facebook	medium	8%	3.2
104	MAU: Monthly active users google	easy	20%	3.3
118	Daily bookings in the US airbnb	hard	5%	3.2
129	Top 3 and bottom 3 courier uber	medium	9%	3.3
140	Daily sales of restaurant 100011 doordash	hard	8%	3.2
150	Countries with above average customers google	easy	15%	3.1
162	Number of orders per brand walmart	easy	41%	3.1
168	Average number of streams in the US tiktok	medium	13%	3.2
172	Comments distribution facebook	hard	13%	3.2
179	Members who ever moved from Microsoft to Google linkedin	medium	31%	3.1
191	Number of replies by group twitter	medium	18%	3.2
194	Daily active users report for new market snap	easy	20%	3.2
213	Interchange revenue by issuer and merchant category visa	easy	70%	3.1

Disclaimer: SQLPad collects questions and their associated data from the internet, but we are not associated with any of the companies or organizations that may be mentioned in these questions. While we strive to provide accurate and up-to-date information, we cannot guarantee the accuracy or completeness of the information provided. Users should exercise their own discretion when using the platform and should not rely solely on the information provided. By using SQLPad, you acknowledge and agree that we are not responsible for any errors or inaccuracies in the information, and that you assume all risks associated with using the platform. You also agree to our terms and conditions.