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
Palantir logo
Palantir
Hard
Software Engineer

Learn an Unfamiliar SQL-Like Query Class, Then Solve Tasks with Its Map and Fold Actions

This round tests how quickly you can learn code you have never seen. You are handed a short class that implements a small SQL-like query language. Fir...

Software Engineering FundamentalsProgramming Languages
59
1
474 people solved
Oct 30, 2026
Amazon logo
Amazon
Hard
Software Engineer

Fix a Buggy Spring Boot Movie Search Against Five Search Rules

You are given an existing Spring Boot backend that powers a movie search feature, and the search returns wrong results. The search logic is complicate...

Software Engineering FundamentalsDebuggingTesting & Quality
203
5
1908 people solved
Sep 30, 2026
Pinterest logo
Pinterest
Medium
Data Scientist

Calculate the Percentage of Highly Active Users by Country

Calculate the Percentage of Highly Active Users by Country The impressions table has these columns: | Column | Meaning | |---|---| | impression_id | I...

Data Manipulation (SQL/Python)SQL
33
8
544 people solved
Sep 24, 2026
Amazon logo
Amazon
Hard
Software Engineer

Debug Failing Tests in a Django Movie Search and Filter API

You are given an existing Django project that serves a movie catalog API, together with a suite of automated tests, several of which fail. You have 60...

Software Engineering FundamentalsDebuggingTesting & Quality
46
1
608 people solved
Sep 9, 2026
Glean logo
Glean
Medium
Data Scientist

SQL: Zero-Filled DAU, Rolling 30-Day MAU, and the MAU Impact of a User-ID Rehash

This SQL round for a data scientist role packed five SQL questions, each with a follow-up, into one hour. The bar was described as error-free answers,...

Data Manipulation (SQL/Python)SQL
6
2
118 people solved
Sep 30, 2026
Waymo logo
Waymo
Medium
Data Scientist Locked

SQL: Count Users With Zero or One Rides per City

Write a PostgreSQL query that counts, per city, the users who have taken zero or one ride in total, including users who never rode. Tests outer joins ...

Data Manipulation (SQL/Python)SQL
23
1
298 people solved
Sep 10, 2026
Databricks logo
Databricks
Medium
Software EngineerNew Grad

Implement Column Pruning and Filter Pushdown on a Query Plan Tree

A query engine represents a SQL query as a tree of plan nodes. You are handed such a tree and asked to "optimize" it. The interviewer does not say whi...

Software Engineering FundamentalsDatabase InternalsTrees
22
1
160 people solved
Sep 11, 2026
Waymo logo
Waymo
Medium
Data Scientist Locked

SQL: Average Ride Rating in Users' First and Third Active Months by City

Write a PostgreSQL query that compares average ride ratings in each user's first and third active months, grouped by city and averaged over individual...

Data Manipulation (SQL/Python)SQL
14
0
117 people solved
Sep 10, 2026
Cohere logo
Cohere
Medium
Data Engineer Locked

Load Daily JSONL LLM Chat Logs Into a Warehouse: Schema, Validation, Dedup, Idempotency

A data engineering take-home: load daily JSONL files of LLM conversation logs from object storage into a warehouse, with schema DDL, parsing, validati...

Data Manipulation (SQL/Python)ETL & Data PipelinesData Quality & Validation
8
0
111 people solved
Sep 22, 2026
DoorDash logo
DoorDash
Easy
Data ScientistSenior+

Measure Customers Ordering from Bottom-Quartile Restaurants

Measure Customers Ordering from Bottom-Quartile Restaurants Write one PostgreSQL SELECT statement or CTE query. Do not create, alter, or modify tables...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
13
1
209 people solved
Jul 27, 2026
Meta logo
MetaMicrosoftAmazon

Also asked at Amazon, Google, Bloomberg, Deloitte

Easy
Software Engineer

Find Customers with No Matching Order

Problem Return the names of customers who have never placed an order. Match Customers.id to Orders.customerId and label the result Customers. The row ...

Data Manipulation (SQL/Python)SQL
1
1
21 people solved
Stripe logo
Stripe
Medium
Software Engineer Locked

Reconcile Monthly Bank-Account Balances Across Two Datasets

Compare bank-account balances for a target calendar month, report match status, and distinguish missing comparison records from zero balances.

Data Manipulation (SQL/Python)SQL
25
0
229 people solved
Aug 31, 2026
Waymo logo
Waymo
Medium
Data Scientist Locked

SQL: Monthly Ride Totals and Average Ratings, Newest Month First

Write a PostgreSQL query that reports, for each calendar month, the total number of rides and the average rating rounded to two decimals, newest month...

Data Manipulation (SQL/Python)SQL
13
0
92 people solved
Sep 10, 2026
Meta logo
Meta
Medium
Data EngineerSenior+ Locked

Find Values Owned Only by the Selected User

Use PostgreSQL to find values belonging to one selected user and no other user, while handling repeated values and shared ownership.

Data Manipulation (SQL/Python)SQL
17
0
151 people solved
Sep 3, 2026
Visa logo
Visa
Medium
Software Engineer

Design an Inventory Service: SQL Schema, Safe Stock Reservations and Analytics

Design an inventory service. The prompt is deliberately vague: you decide which functional and non-functional requirements the service must meet. The ...

System DesignSystem Design FundamentalsTransactions & Isolation
6
0
75 people solved
Sep 27, 2026
Google logo
GoogleMicrosoftAmazon

Also asked at Amazon, Bloomberg, Meta, TCS, EPAM Systems

Easy
Software Engineer

List Email Spellings That Occur More Than Once

Problem List every duplicate email from Person once, under the output label Email. The email field is guaranteed non-NULL and contains no uppercase le...

Data Manipulation (SQL/Python)SQLData Cleaning & Wrangling
1
0
14 people solved
Capital One logo
Capital One
Easy
Data Analyst Locked

Analyze Mission Outcomes and Allocate Response Units

Solve a multi-part data analysis case using mission outcomes and response-unit history. Compute and interpret win rates, compare rest-time groups, han...

Data Manipulation (SQL/Python)Business Case AnalysisSampling & Estimation
55
0
705 people solved
Jul 8, 2026
Waymo logo
Waymo
Medium
Data Scientist Locked

SQL: Users With No Rides in the Most Recent 7-Day Window, Including Non-Riders

Write a PostgreSQL query that lists users with no rides in the most recent 7-day window, including users who never rode. Tests anchoring a date window...

Data Manipulation (SQL/Python)SQL
13
0
117 people solved
Sep 10, 2026
IBM logo
IBM
Medium
Software Engineer

Find Customers Whose Average Website Resource Usage Exceeds 50 Percent

Write one read-only PostgreSQL query that reports customers whose average website resource usage exceeds 50 percent. Schema | Table | Column | Type | ...

Data Manipulation (SQL/Python)SQL
8
0
68 people solved
Aug 28, 2026
Pylon Lending logo
Pylon Lending
Medium
Software Engineer

Build a Chainable Python SQL Query Builder with Where, Alias and Join Support

Implement a small ORM-style query builder in Python. An existing test suite drives it through a fluent API and compares the string returned by render(...

Software Engineering FundamentalsLow-Level Design (OOP)Parsing & Interpreters
5
0
44 people solved
Sep 19, 2026
Previous12...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