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
Shopify logo
Shopify
Easy
Data ScientistSenior+

Predict a Merchant Order Report Query's Output and Find Its One Error

A product analyst wants a report with one row per merchant showing how many completed orders the merchant has and the revenue from those orders. Every...

Data Manipulation (SQL/Python)SQL
0
0
4 people solved
Oct 29, 2026
Salesforce logo
Salesforce
Medium
Software Engineer

Design a coffee ordering system

System Design: Coffee Ordering System Design a system for a coffee shop (and later a chain of stores) that lets customers order drinks for pickup or i...

System DesignSystem Design FundamentalsDistributed Transactions & Idempotency
845
4
7846 people solved
Jan 22, 2026
Meta logo
MetaAmazonGoogle

Also asked at Google, Bloomberg, Revolut, Microsoft

Medium
Software Engineer

Report Seven-Day Revenue Totals and Averages

Problem Report visited_on, amount and average_amount for each complete seven-day window ending on visited_on. amount sums all customer payments over t...

Data Manipulation (SQL/Python)SQL
0
0
15 people solved
Google logo
GoogleTCSAmazon

Also asked at Amazon, Microsoft, Meta, Bloomberg, MAQ Software

Easy
Software Engineer

Delete Repeated Email Rows While Keeping the Smallest ID

Problem Delete duplicate-email rows from Person itself, leaving the row with the smallest id for each email. SQL must use a DELETE statement, not a SE...

Data Manipulation (SQL/Python)SQLData Cleaning & Wrangling
0
0
8 people solved
Microsoft logo
MicrosoftAmazonBloomberg

Also asked at Bloomberg, Google, Meta, Walmart Labs

Medium
Software Engineer

Measure Next-Day Return after Each Player’s First Login

Problem Return fraction: the fraction of all players who logged in on the calendar day immediately after their first recorded login. Round to two deci...

Data Manipulation (SQL/Python)SQL
0
0
9 people solved
Engelhart logo
Engelhart
Medium
Software Engineer

Relational Database Indexes: Read/Write Trade-offs and Tuning a Slow SQL Query

Explain what a relational database index is and how it affects reads and writes, then describe how you would troubleshoot and tune a complex SQL query...

Software Engineering FundamentalsIndexing & Query PerformanceDatabase Internals
1
0
17 people solved
Sep 19, 2026
Google logo
GoogleMicrosoftAmazon

Also asked at Amazon, Bloomberg, Meta, Cognizant

Easy
Software Engineer

Keep Customers without a Referee or Referred by Someone Other Than Two

Problem Return customer names when referee_id is not 2, or when no referee is recorded. A NULL referee_id represents no referral and must be retained....

Data Manipulation (SQL/Python)SQL
1
0
11 people solved
Google logo
GoogleAmazonMicrosoft

Also asked at Microsoft, Bloomberg, Meta, TCS

Easy
Software Engineer

Attach Product Names to Every Sales Record

Problem For every Sales record, report product_name, year and the per-unit price, using the Product lookup. Preserve separate sales rows even when the...

Data Manipulation (SQL/Python)SQL
0
0
10 people solved
Meta logo
Meta
Medium
Data Scientist Locked

Compare Survey Satisfaction for New and Established Users

Write PostgreSQL to compare survey satisfaction for new and established users across countries. The challenge emphasizes date-based cohort rules, inva...

Data Manipulation (SQL/Python)SQL
9
2
161 people solved
Jul 6, 2026
Agoda logo
Agoda
Easy
Data EngineerSenior+ Locked

Find the Longest Calendar-Day Streak with All Employees Present

Identify dates when every employee is present and compute the longest consecutive streak, treating missing attendance as a gap.

Data Manipulation (SQL/Python)SQL
7
0
70 people solved
Sep 11, 2026
Google logo
GoogleAmazonBloomberg

Also asked at Bloomberg, Meta, Microsoft, Accenture

Easy
Software Engineer

Count Exam Attendance for Every Student-Subject Pair

Problem Return student_id, student_name, subject_name and attended_exams for every combination of a Students row and a Subjects row. Count all matchin...

Data Manipulation (SQL/Python)SQL
0
1
12 people solved
Oracle logo
Oracle
Medium
Software EngineerSenior+ Locked

Rank Departments by Student Count

Write a portable SQL query that returns every department with its student count, including departments with zero students. Sort counts descending and ...

Data Manipulation (SQL/Python)SQL
54
1
388 people solved
Aug 21, 2026
Google logo
GoogleAmazonBloombergMicrosoft

Also asked at Bloomberg, Microsoft

Hard
Software Engineer

Compute Daily Cancellations after Excluding Either Banned Participant

Problem For each day from 2013-10-01 through 2013-10-03 inclusive with eligible requests, report Day and Cancellation Rate. A request is eligible only...

Data Manipulation (SQL/Python)SQL
0
0
6 people solved
Meta logo
Meta
Medium
Data Scientist

Count Posts With 10+ Views and Compute View-Weighted Spam/Scam Prevalence

A social media platform's integrity team tracks how often members see harmful content. Write one query that reports two numbers for the period covered...

Data Manipulation (SQL/Python)SQL
0
0
2 people solved
Nov 1, 2026
Chime logo
Chime
Medium
Data Scientist Locked

Define and Analyze Early Engagement

Define an early-engagement metric over users and transactions, implement the selected metric as a read-only relational query, examine trends and segme...

Data Manipulation (SQL/Python)Metrics & KPIsSegmentation & Cohort Analysis
8
0
120 people solved
Aug 17, 2026
Mixpanel logo
Mixpanel
Medium
Data Scientist

Calculate First-Week Retention by Signup Cohort

Compute First-Week Retention by Signup Week You have these tables: | Table | Column | Meaning | |---|---|---| | users | user_id | User identifier. | |...

Data Manipulation (SQL/Python)SQLSegmentation & Cohort Analysis
2
0
30 people solved
Sep 14, 2026
ByteDance logo
ByteDance
Medium
Data Scientist Locked

Find Each User's Earliest Seven-Day Activity Streak

A PostgreSQL interview problem about finding each user's earliest streak of at least seven consecutive active dates. It tests date deduplication, gaps...

Data Manipulation (SQL/Python)SQL
18
0
159 people solved
Aug 3, 2026
Airbnb logo
Airbnb
Medium
Data Engineer Locked

Calculate the Median House Price in Each City

Calculate median house prices by city in PostgreSQL, handling odd and even group sizes, repeated prices, and exact numeric results.

Data Manipulation (SQL/Python)SQL
6
0
45 people solved
Sep 4, 2026
Amazon logo
AmazonGoogleMeta

Also asked at Meta, Bloomberg, Microsoft, PayPal

Easy
Software Engineer

Compute Unit-Weighted Prices across Nonoverlapping Price Periods

Problem Report each product’s average_price, rounded to two decimal places. Each sale uses the price interval covering its purchase_date, with inclusi...

Data Manipulation (SQL/Python)SQL
1
0
10 people solved
ByteDance logo
ByteDance
Medium
Data Scientist

Ads Campaign Creation Log SQL: Submit Count, Weekly Submit Rate, Time on Site

An ads platform lets advertisers create a campaign in a self-serve flow of three pages, followed by a submission: `text objective -> adgroup -> creati...

Data Manipulation (SQL/Python)SQL
0
0
2 people solved
Oct 29, 2026
Previous1234...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