SQL Interview Questions & FAANG Technical Screening Sandbox

Q: Netflix Analytics: Highly Active Streamers

Netflix Analytics is auditing song engagements. Write a query to find the user_id and the total number of streams they have completed, but only for users who have streamed songs more than 5 times. Group by user_id and order by streams descending. Recommended Sandbox Database Schema: SPOTIFYLITE Sample Query Template: ```sql -- Netflix Technical Screening -- Tables available: streams (id, song_id, user_id) -- Goal: Find user_id and total stream counts for users with more than 5 streams. -- Group by user_id and sort by stream count descending. SELECT FROM streams ; ```

Q: Corporate SQL Certification Screening

This assessment contains 17 real-world questions testing inserts, updates, complex loop simulations, window joins, recursive aggregates, and parameters. Toggle each question using the dropdown. Recommended Sandbox Database Schema: STAFFCORP Sample Query Template: ```sql -- Corporate T-SQL Exam Skeleton -- Select a sub-question to load the skeleton SELECT * FROM employees; ```

Question 1

Google Interview: Top Streamed Song Trends

Accepted Answer

Google Analytics needs stream rankings. Write an aggregation joining songs and streams to find the song title, artist name, and total stream count. Filter down only to streams since April 3rd 2026. Group and sort by stream count descending.

Recommended Sandbox Database Schema: SPOTIFYLITE

Sample Query Template:
```sql
-- Google Technical Screening
-- Tables available: songs (id, title, artist_id), streams (id, song_id, stream_date), artists (id, name)
-- Goal: Find song title, artist name, and total stream count for streams since April 3rd 2026.
-- Group and sort by stream count descending.

SELECT 
  
FROM streams st
;
```

Question 2

Stripe Audit: Regional Salary Discrepancy

Accepted Answer

During financial audits, we need to locate employees earning over $100,000 in regional centers. Write a query returning the employee's name, department name, salary, and city. Sort by salary descending.

Recommended Sandbox Database Schema: STAFFCORP

Sample Query Template:
```sql
-- Stripe Technical Screening
-- Tables available: employees (name, salary, city, department_id), departments (name)
-- Goal: Retrieve employee's name, department name, salary, and city where salary > 100,000.
-- Sort by salary descending.

SELECT 
  
FROM employees e
;
```

Question 3

Meta Integrity: Suspicious High-Value Transactions

Accepted Answer

Meta's trust and safety team is auditing bank balances. Write a query to locate high-value accounts having a balance greater than $50,000. Retrieve the customer's name, email, account type, and balance. Join bank_accounts and bank_customers, and sort by balance descending.

Recommended Sandbox Database Schema: APEXBANK

Sample Query Template:
```sql
-- Meta Technical Screening
-- Tables available: bank_accounts (balance, account_type, customer_id), bank_customers (name, email)
-- Goal: Retrieve customer name, email, account type, and balance for accounts > 50,000.
-- Sort by balance descending.

SELECT 
  
FROM bank_accounts a
;
```

Question 4

Amazon SDE: High-Velocity Supplier Restock

Accepted Answer

Amazon's inventory operations require identifying suppliers associated with products that are critical of running out. Write a query to find the supplier's company name, the product's name, and its current stock quantity (stock_qty) where stock_qty is less than 50. Join pos_products and pos_suppliers, and sort by stock_qty ascending.

Recommended Sandbox Database Schema: RETAIL_POS

Sample Query Template:
```sql
-- Amazon Technical Screening
-- Tables available: pos_products (name, stock_qty, supplier_id), pos_suppliers (company_name)
-- Goal: Find supplier's company_name, product's name, and stock_qty where stock_qty < 50.
-- Sort by stock_qty ascending.

SELECT 
  
FROM pos_products p
;
```

Question 5

Netflix Analytics: Highly Active Streamers

Accepted Answer

Netflix Analytics is auditing song engagements. Write a query to find the user_id and the total number of streams they have completed, but only for users who have streamed songs more than 5 times. Group by user_id and order by streams descending.

Recommended Sandbox Database Schema: SPOTIFYLITE

Sample Query Template:
```sql
-- Netflix Technical Screening
-- Tables available: streams (id, song_id, user_id)
-- Goal: Find user_id and total stream counts for users with more than 5 streams.
-- Group by user_id and sort by stream count descending.

SELECT 
  
FROM streams
;
```

Question 6

Corporate SQL Certification Screening

Accepted Answer

This assessment contains 17 real-world questions testing inserts, updates, complex loop simulations, window joins, recursive aggregates, and parameters. Toggle each question using the dropdown.

Recommended Sandbox Database Schema: STAFFCORP

Sample Query Template:
```sql
-- Corporate T-SQL Exam Skeleton
-- Select a sub-question to load the skeleton

SELECT * FROM employees;
```

SQL Mock Interview Screening Mode