PracHub
QuestionsExperienceLearningGuidesInterview Prep
Visa Tools

Visa Tools

Visa Sponsors

Find employers with sponsorship filings

H-1B Odds Calculator

Explore your lottery selection odds

Visa Bulletin

Monthly green-card priority dates

PracHub

Master your tech interviews with 18,000+ real questions from top companies.

Product

  • Questions
  • Learning Tracks
  • Interview Guides
  • Resources
  • Green Card Tracker
  • Premium
  • Practice with AI agents
  • For Universities
  • Careers

Browse

  • By Company
  • By Role
  • By Category
  • Topic Hubs
  • Interview Experiences
  • SQL Questions
  • Blind 75
  • AI Coding Questions
  • Compare Platforms
  • Discord Community

Support

  • support@prachub.com

Legal

  • Privacy Policy
  • Terms of Service
  • About Us

© 2026 PracHub. All rights reserved.

Tech Interview Questions

Practice the exact questions companies are asking right now.

Questions
383
Companies
980
Updated
11.12.2026
383 Questions 980 Companies11.12.2026
PLTCHK testimonial
PLTCHK

"I got asked a hardcore MCM DP question and I saw it on PracHub as well. Solved that question in 5 minutes. Without PracHub I doubt I could solve it in 5 hours. Though somehow didn't get hired, perhaps I guess I solved it too fast? /s"

_The_TaNk_ testimonial
_The_TaNk_

"Believe me i'm a student here jn US. Recently interviewed for MSFT. They asked me exact question from PracHub. I saw it the night before and ignored it cause why waste time on random sites. I legit wanna go back and redo this whole thing if I had chance. Not saying will work for everyone but there is certainly some merit to that website. And i'm gonna use it in future prep from now on like lc tagged"

Chris testimonial
ChrisSenior SWE, LinkedIn

"10 years of experience but never worked at a top company. PracHub's senior-level questions helped me break into FAANG at 35. Age is just a number."

sleepy33 testimonial
sleepy33

"I was skeptical about the 'real questions' claim, so I put it to the test. I searched for the exact question I got grilled on at my last Meta onsite... and it was right there. Word for word."

Jake testimonial
JakeSenior ML Engineer, Lyft

"Got a Google recruiter call on Monday, interview on Friday. Crammed PracHub for 4 days. Passed every round. This platform is a miracle worker."

nuggetlord testimonial
nuggetlord

"I've used LC, Glassdoor, and random Discords. Nothing comes close to the accuracy here. The questions are actually current — that's what got me. Felt like I had a cheat sheet during the interview."

Carlos testimonial
CarlosFull Stack, Shopify

"The solution quality is insane. It covers approach, edge cases, time complexity, follow-ups. Nothing else comes close."

boba.tea.vibes testimonial
boba.tea.vibes

"Legit the only resource you need. TC went from 180k -> 350k. Just memorize the top 50 for your target company and you're golden."

Andy testimonial
AndySWE-II, Google

"PracHub Premium for one month cost me the price of two coffees a week. It landed me a $280K+ starting offer."

couchpotato99 testimonial
couchpotato99

"Literally just signed a $600k offer. I only had 2 weeks to prep, so I focused entirely on the company-tagged lists here. If you're targeting L5+, don't overthink it."

Shruti testimonial
ShrutiData Engineer, Salesforce

"Coaches and bootcamp prep courses cost around $200-300 but PracHub Premium is actually less than a Netflix subscription. And it landed me a $178K offer."

midnightramen testimonial
midnightramen

"I honestly don't know how you guys gather so many real interview questions. It's almost scary. I walked into my Amazon loop and recognized 3 out of 4 problems from your database."

Bianca testimonial
BiancaFrontend Eng, Figma

"Discovered PracHub 10 days before my interview. By day 5, I stopped being nervous. By interview day, I was actually excited to show what I knew."

tambrahm007 testimonial
tambrahm007

"I recently cleared Uber interviews (strong hire in the design round) and all the questions were present in prachub."

toa testimonial
toa

"The search is what sold me. I typed in a really niche DP problem I got asked last year and it actually came up, full breakdown and everything. These guys are clearly updating it constantly."

PLTCHK testimonial
PLTCHK

"I got asked a hardcore MCM DP question and I saw it on PracHub as well. Solved that question in 5 minutes. Without PracHub I doubt I could solve it in 5 hours. Though somehow didn't get hired, perhaps I guess I solved it too fast? /s"

_The_TaNk_ testimonial
_The_TaNk_

"Believe me i'm a student here jn US. Recently interviewed for MSFT. They asked me exact question from PracHub. I saw it the night before and ignored it cause why waste time on random sites. I legit wanna go back and redo this whole thing if I had chance. Not saying will work for everyone but there is certainly some merit to that website. And i'm gonna use it in future prep from now on like lc tagged"

Chris testimonial
ChrisSenior SWE, LinkedIn

"10 years of experience but never worked at a top company. PracHub's senior-level questions helped me break into FAANG at 35. Age is just a number."

sleepy33 testimonial
sleepy33

"I was skeptical about the 'real questions' claim, so I put it to the test. I searched for the exact question I got grilled on at my last Meta onsite... and it was right there. Word for word."

Jake testimonial
JakeSenior ML Engineer, Lyft

"Got a Google recruiter call on Monday, interview on Friday. Crammed PracHub for 4 days. Passed every round. This platform is a miracle worker."

nuggetlord testimonial
nuggetlord

"I've used LC, Glassdoor, and random Discords. Nothing comes close to the accuracy here. The questions are actually current — that's what got me. Felt like I had a cheat sheet during the interview."

Carlos testimonial
CarlosFull Stack, Shopify

"The solution quality is insane. It covers approach, edge cases, time complexity, follow-ups. Nothing else comes close."

boba.tea.vibes testimonial
boba.tea.vibes

"Legit the only resource you need. TC went from 180k -> 350k. Just memorize the top 50 for your target company and you're golden."

Andy testimonial
AndySWE-II, Google

"PracHub Premium for one month cost me the price of two coffees a week. It landed me a $280K+ starting offer."

couchpotato99 testimonial
couchpotato99

"Literally just signed a $600k offer. I only had 2 weeks to prep, so I focused entirely on the company-tagged lists here. If you're targeting L5+, don't overthink it."

Shruti testimonial
ShrutiData Engineer, Salesforce

"Coaches and bootcamp prep courses cost around $200-300 but PracHub Premium is actually less than a Netflix subscription. And it landed me a $178K offer."

midnightramen testimonial
midnightramen

"I honestly don't know how you guys gather so many real interview questions. It's almost scary. I walked into my Amazon loop and recognized 3 out of 4 problems from your database."

Bianca testimonial
BiancaFrontend Eng, Figma

"Discovered PracHub 10 days before my interview. By day 5, I stopped being nervous. By interview day, I was actually excited to show what I knew."

tambrahm007 testimonial
tambrahm007

"I recently cleared Uber interviews (strong hire in the design round) and all the questions were present in prachub."

toa testimonial
toa

"The search is what sold me. I typed in a really niche DP problem I got asked last year and it actually came up, full breakdown and everything. These guys are clearly updating it constantly."

Showing 20 results
Amazon logo
Amazon
Easy
Data Scientist

Find recommended friend pairs by shared listening

Problem (SQL) You work on a music app and want to recommend new friend connections based on listening similarity. Tables Assume the following schemas:...

Data Manipulation (SQL/Python)SQL
16
1
170 people solved
Nov 20, 2025
Stripe logo
Stripe
Medium
Product Manager

SQL for AML Review: Customers With Two or More Suspicious Receipt Numbers

Visa's anti-money-laundering (AML) team flags potentially suspicious transactions so the company stays compliant with financial regulations worldwide....

Data Manipulation (SQL/Python)SQL
1
0
18 people solved
Mar 27, 2025
Uber logo
Uber
Medium
Data Scientist

Write SQL for fares and age-band counts

You have two tables. Schema: - drivers(driver_id VARCHAR PRIMARY KEY, name VARCHAR, date_of_birth DATE) - trips(trip_id VARCHAR PRIMARY KEY, driver_id...

Data Manipulation (SQL/Python)SQL
5
1
66 people solved
Oct 13, 2025
ByteDance logo
ByteDance
Medium
Data Scientist

Find top-paid employee per department

Given the following tables: 1) employees - employee_id INT PRIMARY KEY - employee_name VARCHAR 2) employee_department - employee_id INT - department_i...

Data Manipulation (SQL/Python)SQL
6
0
56 people solved
Nov 12, 2025
Netflix logo
Netflix
Medium
Data Scientist

Write SQL for DAU and first-purchase conversion

Today is 2025-09-01. Using the schema and sample data below, write a single ANSI-SQL query that returns one row per day for the last 7 days (2025-08-2...

Data Manipulation (SQL/Python)SQL
28
0
231 people solved
Oct 13, 2025
Medium
Data Scientist

Solve window-function SQL without joins

You must use only window functions (no JOINs). CTEs are allowed. Given the schemas and tiny samples below, write SQL for each sub-question and explain...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
14
0
106 people solved
Oct 13, 2025
Amazon logo
Amazon
Medium
Data Scientist

Design idempotent daily loads with deduping

You need to load the last 7 days of orders into a large fact table from a noisy staging feed. Assume today is 2025-09-01. Requirements: idempotent rer...

Data Manipulation (SQL/Python)ETL & Data PipelinesData Cleaning & Wrangling
9
0
137 people solved
Oct 13, 2025
Microsoft logo
Microsoft
Easy
Data ScientistSenior+ Locked

Query departments and top earners

This question evaluates proficiency in relational data manipulation, including multi-table joins, grouping and aggregation to identify departments wit...

Data Manipulation (SQL/Python)SQL
25
0
245 people solved
Apr 1, 2026
Amazon logo
Amazon
Medium
Data Scientist

Calculate Regional Revenue and Identify Top Customers

Customers | customer_id | name | region | |-------------|-------|--------| | 1 | Alice | East | | 2 | Bob | West | | 3 ...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
24
1
158 people solved
Jul 12, 2025
Roblox logo
Roblox
Medium
Data ScientistSenior+

Compare ROW_NUMBER, RANK, and DENSE_RANK for Top-k Results

Compare ROW_NUMBER, RANK, and DENSE_RANK for Top-k Results Explain how ROW_NUMBER, RANK, and DENSE_RANK differ when selecting top results within a gro...

Data Manipulation (SQL/Python)SQL
3
0
41 people solved
Nov 11, 2025
Meta logo
Meta
Medium
Data Scientist

Compute ad revenue metrics by geography in SQL

You work on a marketplace app that shows shop ads. You are given the following tables. Assumptions - All timestamps are stored in UTC. - “Revenue” is ...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
10
1
110 people solved
Oct 14, 2025
Coinbase logo
Coinbase
Medium
Data Scientist

Compute adoption, latency, and cross-region transactions

Invented schema: users(user_id INT PRIMARY KEY, user_region STRING, adopted_at TIMESTAMP NULL) transactions(txn_id INT PRIMARY KEY, user_id INT, txn_t...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
5
0
69 people solved
Oct 13, 2025
OpenAI logo
OpenAI
Hard
Data Scientist Locked

Compute churn with re-subscriptions

This question evaluates proficiency in event-time data manipulation, temporal aggregation, and subscription-state logic for computing conversion and r...

Data Manipulation (SQL/Python)SQLSegmentation & Cohort Analysis
20
0
179 people solved
Jan 15, 2026
Microsoft logo
Microsoft
Medium
Data Scientist

Find common friends from directed edges

You have a directed edge list that records who followed whom. A mutual “friendship” exists only if both directions appear (A→B and B→A). Schema and sa...

Data Manipulation (SQL/Python)GraphsSQL
18
0
127 people solved
Oct 13, 2025
Capital One logo
Capital One
Medium
Data Analyst

Find top category per region in Aug 2025

You are given the following schema and sample data. Schema: - customers(customer_id INT, name TEXT, region TEXT) - orders(order_id INT, customer_id IN...

Data Manipulation (SQL/Python)SQL
17
0
115 people solved
Oct 13, 2025
TikTok logo
TikTok
Medium
Data Scientist

Tiktok DS Interview Questions

Scenario: You are provided with two tables: minute_streamed and minute_viewed. The minute_streamed table records each minute of streaming activity, wh...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
26
1
196 people solved
Jun 26, 2025
Meta logo
Meta
Medium
Data Scientist

Compute feed ad frequency and retention in SQL

Assume today is 2025-09-01. Schema and tiny samples: feed_impressions(impression_id, user_id, impression_time, content_type, feed_position, session_id...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
10
0
81 people solved
Oct 13, 2025
Airbnb logo
Airbnb
Medium
Data Scientist

Aggregate User Activity, Fit Regression, Interpret Coefficients

user_metrics +----------+------------+---------+--------+-----------+ | user_id | activity_dt| variant | clicks | purchases | +----------+-----------...

Data Manipulation (SQL/Python)Regression & Statistical ModelingSQL
119
0
396 people solved
Jul 12, 2025
DoorDash logo
DoorDash
Hard
Analytics Engineer

Compute Fitness App DAU

You are working on a fitness app. The schema is: users(user_id BIGINT, signup_ts TIMESTAMP, timezone VARCHAR, is_test_user BOOLEAN) and app_events(eve...

Data Manipulation (SQL/Python)SQL
16
1
165 people solved
Oct 12, 2025
Discord logo
Discord
Hard
Data Engineer

Design Video Call Analytics Tables

You are building analytics tables for Discord video calls. Video-call activity is recorded from both client-side and server-side logs. Design a data m...

System DesignDimensional ModelingSQL
34
0
237 people solved
Apr 3, 2026
Previous1...111213...20Next
Popular Categories
SQLBlind 75
Daily Quest

Sign in to earn XP for every problem you solve.

Choose your next challenge

All learning

Blind 75

75 free coding problems to build your foundations, with hints, explanations, and a progress checklist.

Arrays · Graphs · Dynamic programming

Explore Blind 75

ML System Design

Work through the decisions behind machine learning systems, from data to serving.

Data · Models · Evaluation

Explore the course

System Design Interview

Practice reasoning about architecture, scale, and the tradeoffs that shape a system.

Architecture · Scale · Tradeoffs

Explore the course

Explore by company

All companies
  • Meta
  • Google
  • Amazon
  • Apple
  • Microsoft
  • Netflix
  • Capital One
  • TikTok
  • DoorDash
  • Uber
  • Coinbase
  • Airbnb
  • LinkedIn
  • Salesforce
  • Snapchat
  • Spotify
  • PayPal
  • Lyft
  • Pinterest
  • Anthropic
  • OpenAI
  • Databricks
  • Rippling
  • Jane Street

Explore by role

  • Data Scientist
  • Software Engineer
  • Machine Learning Engineer
  • Product Manager
  • Data Engineer
  • Data Analyst
  • Frontend Engineer
  • Backend Engineer
  • Site Reliability Engineer
  • Technical Program Manager

Explore by category

  • Blind 75
  • Coding & Algorithms
  • System Design
  • Machine Learning
  • ML System Design
  • SQL & Python
  • Analytics & Experimentation
  • Behavioral & Leadership
  • Statistics & Math
  • Product / Decision Making
  • Product Design & Strategy
  • SWE Fundamentals

Popular interview guides

  • Meta SWE
  • Meta DS
  • Meta PM
  • Google SWE
  • Google DS
  • Google MLE
  • Amazon SWE
  • Amazon DS
  • Amazon DE
  • Apple SWE
  • Apple MLE
  • Microsoft SWE
  • Microsoft DS
  • TikTok SWE
  • TikTok DS
  • Uber SWE
  • Uber DS
  • DoorDash SWE
  • DoorDash DS
  • Airbnb SWE
  • Airbnb DS
  • LinkedIn SWE
  • LinkedIn DS
  • Netflix SWE
  • Coinbase SWE
  • Capital One DS
  • OpenAI SWE
  • Anthropic SWE

Popular question categories

  • Blind 75
  • Meta Coding
  • Google System Design
  • Amazon Coding
  • Meta Analytics
  • Google ML
  • Amazon System Design
  • Capital One SQL
  • TikTok ML
  • Meta SQL
  • Uber Analytics
  • DoorDash Coding
  • Google Coding
  • Netflix System Design
  • Airbnb Analytics
  • LinkedIn SQL