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
Elsevier logo
Elsevier
Easy
Data Scientist

Load a Results File in pandas and Compute Overall and Per-Group Pass/Fail Rates

In a data scientist technical round, after a project discussion, you get a short pandas exercise: you are given a file, you read it into Python, and y...

Data Manipulation (SQL/Python)Pandas & Python DataData Cleaning & Wrangling
0
0
1 people solved
Jul 14, 2026
Meta logo
Meta
Easy
Data Scientist Locked

Compute this-year spend share of last-year whales

This question evaluates proficiency in data manipulation and analytics engineering, specifically SQL and Python skills for aggregations, joins, calend...

Data Manipulation (SQL/Python)SQLSegmentation & Cohort Analysis
6
1
48 people solved
Feb 15, 2026
Intuit logo
Intuit
Easy
Data Scientist

Compute monthly signups, conversion, and YoY growth

You work at a subscription company and are given a user-level table. Table company_users - id (INT, PK) — user/customer id - signup_date (DATE) — date...

Data Manipulation (SQL/Python)SQLSegmentation & Cohort Analysis
14
1
204 people solved
Nov 8, 2025
Meta logo
Meta
Medium
Data Scientist Locked

Analyze advertiser spend by source

This question evaluates proficiency in data manipulation and analytics using SQL or Python, testing skills such as joins, time-based filtering, cohort...

Data Manipulation (SQL/Python)SQLSegmentation & Cohort Analysis
7
0
55 people solved
Feb 9, 2026
TikTok logo
TikTok
Medium
Data Scientist

Analyze shopping funnel with joins and windows

Write SQL (PostgreSQL) to analyze a 4-step shopping funnel: view_product → add_to_cart → checkout_start → purchase. Use the schema and sample data bel...

Data Manipulation (SQL/Python)SQLUser Behavior & Funnels
19
0
159 people solved
Oct 13, 2025
Meta logo
Meta
Medium
Data Scientist

Define and analyze new-vs-existing activity

Ambiguous product question: Are existing users more active than new users over the last 28 days (ending today = 2025-09-01)? 1) Propose two reasonable...

Data Manipulation (SQL/Python)Metrics & KPIsSegmentation & Cohort Analysis
5
0
78 people solved
Oct 13, 2025
PayPal logo
PayPal
Medium
Data Scientist

Compare WHERE vs HAVING with aggregates

Compare WHERE vs HAVING with aggregates Filter groups based on an aggregate and explain WHERE vs HAVING. Provide a query that returns merchants with c...

Data Manipulation (SQL/Python)SQL
4
0
59 people solved
Jul 31, 2025
Meta logo
Meta
Medium
Data Scientist

Write SQL/pandas for KPI anomaly

Write SQL (and outline equivalent pandas) for a KPI anomaly investigation. Assume today = '2025-09-01'. Schema: Users(user_id INT, country TEXT, signu...

Data Manipulation (SQL/Python)Metric DiagnosticsSQL
15
0
124 people solved
Oct 13, 2025
Instacart logo
Instacart
Hard
Analytics Engineer

Data model for a grocery delivery marketplace: fact tables, dimensions and grain

Design the analytics data model for a grocery delivery marketplace. Customers place orders for items sold by retail stores; shoppers pick the items in...

System DesignDimensional Modeling
0
0
2 people solved
Mar 27, 2026
Meta logo
Meta
Medium
Data Scientist

Calculate Average Session Length and Compare App Performance

user_sessions +---------+------------+------------+---------------------+---------------------+ | user_id | session_id | app | session_start ...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
127
0
339 people solved
Jul 12, 2025
Tools For Humanity logo
Tools For Humanity
Easy
Data Scientist

Compute reply-based engagement metrics

You work on a microblogging app (Twitter-like). Posts and replies are stored in the tables below. Tables all_post - post_id BIGINT PK - post_author_id...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
4
0
64 people solved
Aug 29, 2025
Meta logo
Meta
Medium
Data Scientist Locked

Count Recent High-Volume Call Users

This question evaluates SQL data manipulation and analytical querying skills, including time-window filtering, joins between user and call tables, rol...

Data Manipulation (SQL/Python)SQL
25
1
168 people solved
Mar 14, 2026
Meta logo
Meta
Easy
Data Scientist

Compute reply-based user metrics in 7 days

You are analyzing discussions on a social platform. Tables all_post - post_id (BIGINT, PK) - post_author_id (BIGINT, FK → user.user_id) - post_creatio...

Data Manipulation (SQL/Python)SQL
22
1
192 people solved
Dec 18, 2025
Meta logo
Meta
Medium
Data Scientist

Analyze spend cohort and source shifts

You work on an ads platform. Assume all timestamps are in UTC. Interpret last year as calendar year 2023 and this year as calendar year 2024. Tables: ...

Data Manipulation (SQL/Python)SQLSegmentation & Cohort Analysis
12
2
88 people solved
Feb 23, 2026
TikTok logo
TikTok
Medium
Product Manager

Estimating Average Reciprocal Follow Connections per TikTok User

Estimate how many mutual follows the average TikTok user has, where a mutual follow is a pair of accounts that follow each other. Walk through your as...

Product / Decision MakingEstimation & Market Sizing
0
0
5 people solved
Jul 31, 2025
Clickhouse logo
Clickhouse
Medium
Data Engineer Locked

Answer SQL And Data Warehouse Fundamentals For A Data Engineering Interview

Practice data engineering fundamentals across SQL set operations, anti-joins, top-N window queries, and warehouse modeling. The prompt covers UNION ve...

Data Manipulation (SQL/Python)Dimensional ModelingSQL
13
0
91 people solved
May 19, 2026
Meta logo
Meta
Medium
Data Scientist

Compute time-spent percentage by app category

You work on Oculus app engagement analytics. Tables user_activity - user_id (BIGINT) - date (DATE) — day of activity (assume UTC) - app_id (INT) - ses...

Data Manipulation (SQL/Python)SQL
8
0
62 people solved
Aug 17, 2025
Meta logo
Meta
Easy
Data Scientist

Compute ads revenue by geography in SQL

You have ad delivery logs for a shop-ads system. Tables ad_impressions - impression_id STRING (PK) - ts TIMESTAMP (UTC) - user_id STRING - shop_id STR...

Data Manipulation (SQL/Python)SQL
32
5
233 people solved
Jan 17, 2026
Meta logo
Meta
Medium
Data Scientist Locked

Analyze Multiple-Account Users in SQL

This question evaluates a data scientist's ability to perform SQL-level user- and account-level aggregation, grouping, and NULL-aware filtering to com...

Data Manipulation (SQL/Python)SQL
3
0
56 people solved
Feb 9, 2026
Meta logo
Meta
Medium
Data Scientist

Compute unread and multi-account user percentages

You’re given two tables. Write ANSI-SQL to answer parts (a)–(d). Treat a notification as unread if read_at IS NULL. Denominator for user-level percent...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
15
0
101 people solved
Oct 13, 2025
Previous1...17181920Next
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