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

Find Monthly Top Customers Excluding High-Frequency Users

A PostgreSQL interview problem about ranking monthly customers while excluding users who meet a high-frequency threshold. Candidates must build the el...

Data Manipulation (SQL/Python)SQL
7
0
74 people solved
Jul 27, 2026
Bloomberg logo
BloombergAmazonMeta

Also asked at Meta, Microsoft, Intuit, Google, BCG, TikTok, Ozon, Dell, HCL

Hard
Software Engineer

Find Employees in Their Department’s Top Three Salary Levels

Problem Find all high earners in each department: a high earner has one of that department’s three largest distinct salaries. Return Department, Emplo...

Data Manipulation (SQL/Python)SQL
0
0
8 people solved
Amazon logo
AmazonBloombergMicrosoft

Also asked at Microsoft, Google, Meta, Wayfair

Medium
Software Engineer

Find the Final Boarding Person before the Bus Limit Is Exceeded

Problem Return person_name for the last person who boards in turn order without exceeding the bus capacity of 1000 kilograms. Boarding follows the que...

Data Manipulation (SQL/Python)SQL
0
0
7 people solved
Pinterest logo
Pinterest
Easy
Data Scientist

Write SQL for top categories and highly active users

You are given three tables: 1) impression Event-level table of user impressions. - impression_id BIGINT (PK) - user_id BIGINT (FK → user.user_id) - pi...

Data Manipulation (SQL/Python)SQL
77
3
524 people solved
Dec 5, 2025
Google logo
GoogleMetaAmazon

Also asked at Amazon, Bloomberg, Microsoft, Swiggy, Starbucks

Medium
Software Engineer

Measure Immediate Deliveries among Customers’ First Orders

Problem Return immediate_percentage: the percentage of customers whose first order was immediate, rounded to two decimal places. An order is immediate...

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

Analyze Thirty-Day Ad Performance with SQL

Work through a multi-part advertising SQL interview covering top ads by impressions, CTR by ad type, campaign conversion value per exposed user, and p...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
7
0
84 people solved
May 22, 2026
Agoda logo
Agoda
Easy
Data EngineerSenior+ Locked

Return Every Employee with a Mapped or Default Unique ID

Join employees to unique-ID mappings while preserving unmatched employees and applying an explicit fallback identifier.

Data Manipulation (SQL/Python)SQL
3
0
49 people solved
Sep 11, 2026
Google logo
Google
Easy
Business Intelligence Engineer

Quick-Fire SQL and Python Fundamentals: GROUP BY, JOINs, HAVING, Lists vs Tuples

A recruiter screen for a business intelligence role opens by asking you to rate your own SQL and Python skills on a scale of 1 to 5, then moves into a...

Data Manipulation (SQL/Python)SQLPandas & Python Data
0
0
1 people solved
Nov 2, 2026
The New York Times logo
The New York Times
Easy
Data Analyst

Write SQL for content-view analytics

Context You work with page-view event logs and need to compute several engagement/usage summaries. Assume a single table: page_views | column | type |...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
5
0
83 people solved
Jan 17, 2026
Amazon logo
AmazonGoogleMeta

Also asked at Meta, Bloomberg, Microsoft, TCS, Cognizant, Accenture

Easy
Software Engineer

List Distinct Authors Who Viewed Their Own Articles

Problem Return each author who has viewed at least one article they wrote. Equal author_id and viewer_id mean the same person. Label the output id, re...

Data Manipulation (SQL/Python)SQL
1
0
7 people solved
Meta logo
Meta
Hard
Data Scientist

Write SQL for reply-based recipient metrics

You work on a social product and are given two tables. Assumptions (use these unless you state otherwise): - All timestamps are in UTC. - A “reply” is...

Data Manipulation (SQL/Python)SQL
57
2
540 people solved
Mar 5, 2026
Microsoft logo
MicrosoftGoogleMeta

Also asked at Meta, Amazon, Bloomberg

Medium
Software Engineer

Aggregate Monthly Transaction Totals and Approved Totals

Problem For each calendar month and country, report month, country, trans_count, approved_count, trans_total_amount and approved_total_amount. Month u...

Data Manipulation (SQL/Python)SQL
0
0
6 people solved
Cohere logo
Cohere
Medium
Data Engineer Locked

Design a Conversation Log Ingestion Pipeline

This question evaluates a data engineer's competency in designing robust daily ingestion and ETL pipelines for conversation logs, covering schema and ...

System DesignETL & Data PipelinesBatch & Stream Processing
18
0
183 people solved
May 30, 2026
Amazon logo
AmazonGoogleBloomberg

Also asked at Bloomberg, Meta, Microsoft, Cognizant

Medium
Software Engineer

Read Product Prices at the Fixed Snapshot Date

Problem Return product_id and price as of 2019-08-16 for every distinct product_id appearing anywhere in Products. Each product starts at price 10. A ...

Data Manipulation (SQL/Python)SQL
0
0
6 people solved
Agoda logo
Agoda
Easy
Data EngineerSenior+ Locked

Sum Employee Working Time from Ordered Check-In and Check-Out Events

Pair ordered employee attendance events and total working seconds, including multiple shifts and intervals crossing midnight.

Data Manipulation (SQL/Python)SQL
3
0
29 people solved
Sep 11, 2026
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
1 people solved
Nov 1, 2026
Amazon logo
AmazonBloombergGoogle

Also asked at Google, Meta, Microsoft, TCS

Easy
Software Engineer

Count Visits with No Transactions for Each Customer

Problem Find each customer with at least one Visits row having no matching transaction, and report customer_id and count_no_trans, the number of such ...

Data Manipulation (SQL/Python)SQL
0
0
7 people solved
DoorDash logo
DoorDash
Easy
Data ScientistSenior+ Locked

Calculate the Monthly Share of High-Frequency Customers

A PostgreSQL interview problem about measuring the monthly percentage of customers who place more than 30 deliveries. It tests calendar-month aggregat...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
24
0
159 people solved
Jul 27, 2026
Microsoft logo
MicrosoftGoogleAmazon

Also asked at Amazon, Meta, Bloomberg

Easy
Software Engineer

Match the Diabetes Prefix at a Space-Delimited Condition Boundary

Problem Return patient_id, patient_name and conditions for patients with a condition code beginning DIAB1. Conditions contains zero or more codes sepa...

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

Classify Tree Nodes in SQL

Classify each tree node as Root, Inner, or Leaf in PostgreSQL using its parent ID and whether it has children, returning one classification per node.

Data Manipulation (SQL/Python)SQLTrees
6
0
89 people solved
Sep 9, 2026
Previous1...456...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