SQL FOR EVERYONE

SQL FOR DATA ANALYSTS , DATA ENGINEERS AND DATA SCIENTISTS

MORE THAN 70 + SQL QUERIES ASKED IN FAANG AND MAANG - PRODUCT BASED COMPANIES - WITH SOLUTIONS

AND SQL CONCEPTS EXPLAINED

THIS COURSE HAS COVERED THE MANY OF THE SQL QUERIES COVERED IN DIFFERENT PLATFORMS LIKE LEETCODE, DATALEMUR AND SO NO...

1 Signup Activation Rate [TikTok SQL Interview Question]

2 Supercloud Customer [Microsoft SQL Interview Question]

3 Card Launch Success [JPMorgan Chase SQL Interview Question]

4 Pharmacy Analytics (Part 4) [CVS Health SQL Interview Question]

5 First Transaction [Etsy SQL Interview Question]

6 Photoshop Revenue Analysis [Adobe SQL Interview Question]

7 Pharmacy Analytics (Part 2) [CVS Health SQL Interview Question]

8 Pharmacy Analytics (Part 1) [CVS Health SQL Interview Question]

9 Pharmacy Analytics (Part 3) [CVS Health SQL Interview Question]

10 Pharmacy Analytics (Part 4) [CVS Health SQL Interview Question]

11 LinkedIn Power Creators (Part 2) [LinkedIn SQL Interview Question]

12 Email Table Transformation [Facebook SQL Interview Question]

13 Average Deal Size (Part 2) [Salesforce SQL Interview Question]

14 Y-on-Y Growth Rate [Wayfair SQL Interview Question]

15 User Shopping Sprees [Amazon SQL Interview Question]

16 2nd Ride Delay [Uber SQL Interview Question]

17 Histogram of Users and Purchases [Walmart SQL Interview Question]

18 User Session Activity [Twitter SQL Interview Question]

19 Unique Money Transfer Relationships [PayPal SQL Interview Question]

20 ApplePay Volume

21 Uniquely Staffed Consultants [Accenture SQL Interview Question]

22 Senior Managers [Google SQL Interview Question]

23 Sending vs. Opening Snaps [Snapchat SQL Interview Question]

24 Data Science Skills [LinkedIn SQL Interview Question]

25 Histogram of Tweets [Twitter SQL Interview Question]

26 Average Post Hiatus (Part 1) [Facebook SQL Interview Question]

27 Laptop vs. Mobile Viewership [New York Times SQL Interview Question]

28 Teams Power Users [Microsoft SQL Interview Question]

29 Duplicate Job Listings [Linkedin SQL Interview Question]

30 Cities With Completed Trades [Robinhood SQL Interview Question]

31 Final Account Balance [Paypal SQL Interview Question]

32 QuickBooks vs TurboTax [Intuit SQL Interview Question]

33 App Click-through Rate (CTR) [Facebook SQL Interview Question]

34 User's Third Transaction [Uber SQL Interview Question]

35 Active User Retention [Facebook SQL Interview Question]

36 Webinar Popularity [Snowflake SQL Interview Question]

37 Monthly Merchant Balance [Visa SQL Interview Question]

38 Tweets' Rolling Averages [Twitter SQL Interview Question]

39 Who Made Quota_Oracle SQL Interview Question

40 Highest Number of Products [eBay SQL Interview Question]

41 Spare Server Capacity [Microsoft SQL Interview Question]

42 Top Rated Businesses [Yelp SQL Interview Question]

43 Ad Campaign ROAS [Google SQL Interview Question]

44 Trade In Payouts [Apple SQL Interview Question]

45 Cumulative Purchases by Product Type [Amazon SQL Interview Question]

46 Invalid Search Results [Google SQL Interview Question]

47 Repeat Purchases on Multiple Days [Stitch Fix SQL Interview Question]

48 International Call Percentage [Verizon SQL Interview Question]

49 Follow-Up Airpod Percentage [Apple SQL Interview Question]

50 Subject Matter Experts [Accenture SQL Interview Question]

51 Compressed Mode [Alibaba SQL Interview Question]

52 Consecutive Filing Years [Intuit SQL Interview Question]

53 Spotify Streaming History [Spotify SQL Interview Question]

54 Average Review Ratings [Amazon SQL Interview Question]

55 Highest-Grossing Items [Amazon SQL Interview Question]

56 Queries Quality and Percentage

57 Reported Posts

58 Customers Who Bought Products A and B but Not C

59 Game Play Analysis IV

60 Game Play Analysis III

61 Highest Grade For Each Student

62 Recyclable and Low Fat Products

63 Invalid Tweets

64 The Number of Rich Customers

65 The Latest Login in 2020

66 Game Play Analysis I

67 Warehouse Manager

68 Customer Placing the Largest Number of Orders

69 Find Total Time Spent by Each Employee

70 Immediate Food Delivery I

71 Bank Account Summary II

72 Actors and Directors Who Cooperated At Least Three Times

73 Customer Order Frequency

74 Daily Leads and Partners

75 Page Recommendations

76 Sellers With No Sales

77 Sales Person

78 Employees With Missing Information

79 Grand Slam Titles

80 Find the Team Size

81 Students With Invalid Departments

82 Department Highest Salary

83 Maximum Transaction Each Day

84 The Most Recent Orders for Each Product

85 Game Play Analysis II

86 Project Employees III

87 Find the Quiet Students in All Exams

88 Leetflex Banned Accounts

89 Friendly Movies Streamed Last Month

90 Rank Scores

91 Consequtive Numbers

92 Department Top Three Salaries

93 Classes More Than 5 Students

94 Swap_Salary

95 User Activity for the Past 30 Days I

96 Market Analysis I

97 Capital Gain_Loss

98 Top Travellers

99 Customer Who Visited but Did Not Make Any Transactions

100 Workers With The Highest Salaries

101 Most Profitable Companies

102 Activity Rank

103 Finding User Purchases

With Advanced Concepts