SQL Interview Questions

I leaned pretty heavily on this sub and others while prepping, so wanted to give back by sharing my experience interviewing for an L5 BIE (Business Intelligence Engineer) role at Amazon. **TL;DR** – R

I think I got the online assessment (OA) for free by mass applying. Many people said they got 45 minutes, but mine was 90 minutes for the code signal 4 parts. It was progressive; you had to solve one

Design the Data Model for a Promotion Posting System Design a database schema for Netflix's internal tool used to post ads. Netflix employees use this tool to post trailers, clips, and announcements

Design the Data Model for an Ads Demand Platform This is a database design question. You need to build the database schema for an advertising platform like Netflix. The system follows a specific hie

LeetCode #176: Second Highest Salary. Difficulty: Medium. Topics: Database. Asked at Infosys in the last 6 months.

LeetCode #1907: Count Salary Categories. Difficulty: Medium. Topics: Database. Asked at Pornhub in the last 6 months.

LeetCode #176: Second Highest Salary. Difficulty: Medium. Topics: Database. Asked at LTIMindtree in the last 6 months.

LeetCode #1321: Restaurant Growth. Difficulty: Medium. Topics: Database. Asked at Revolut in the last 6 months.

Hey, I will try to tell the experience in as much detail as I can :) Details: Education: BTech in Computer Science Title/Level: Software developer intern Location: Bangalore(remote) Joining: Summer 2023 (May- June) - 8...

It is an insurance company, I’m a finance sophomore and It’s my first ever internship interview and first ever zoom interview, what type of behavioral questions are most common in these positions? Sho

I encountered the same problem in three online assesment. Unfortuntely, I was not able to solve it in all three cases. Your friend has N different kind of candies each...

LeetCode #1251: Average Selling Price. Difficulty: Easy. Topics: Database. Asked at PayPal in the last 6 months.

I have interview coming up for Manager, Analytics Engineering Role. There are two rounds: **SQL:** The interview will focus on assessing your SQL expertise, including writing complex queries, optimizi

Hey, I recently received an interview invitation for the Data Scientist - Fraud Strategy role at Marcus by Goldman Sachs which is a 45-minute coderpad interview and wanted to reach out for any guidanc

Q1: similar to question 1 in this post: https://leetcode.com/discuss/interview-question/4508854/IBM-Online-Assessment-Backend-Engineer except instead of votes they passed in cost as a parameter and wanted the highest rated restaraunt whose estimated cost was at most...

Hi Guys, Do you know what kind of questions does coinbase ask for senior data engineer for SQl and data modeling round ?

Completed last week: I got 5 SQL and 2 Python questions and successfully answered all of them, but I still didn’t move forward to the next round. No idea why—maybe the interviewer just didn’t like me?

Q1. Given multi line string of SQL syntax, extract the table names. sql_1 = "SELECT t1.id, t2.id FROM table1 t1 LEFT OUTER JOIN table2 t2 ON t2.id = t1.id" sql_2 = "SELECT...

Position: Data Engineer /* Write SQL considering scalability to find the count of New Unique Users logging in by Date? Assume that this is history data and size is around...

Interview process started with a recruiter reachout on Linkedin. Total process took around 4 weeks. 1st technical phone screen: 60 mins. 1 medium sql and 1 easy python coding question. SQL:...

Hello, sharing an sql question in a recent interview I had with TikTok for Data Scientist position: tiktok_req table ID DAY (YYYY-MM-DD) PREDICTED (takes value of 1 or 0) ACTUAL (takes value of 1...

OpenAI Fraud and Trust Team phone/video interview: For Fraud / Trust & Safety related positions. I have 10+ years of experience. The interview mainly focused on my job responsibilities as stated on my

Company: Google Role: Cloud Data Engineer YOE: 9yrs Round : Phone Interview Location: USA, Remote there was two questions : 1. Data Modelling and SQL - Asked to design a Data model for movie booking of...

LeetCode #175: Combine Two Tables. Difficulty: Easy. Topics: Database. Asked at Google in the last 6 months.

LeetCode #1757: Recyclable and Low Fat Products. Difficulty: Easy. Topics: Database. Asked at Google in the last 6 months.