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

Find top-paid employee per department

Tables Assume the company stores employee compensation by department assignment. employee_dept_salary - employee_id INT - employee_name VARCHAR - depa...

Data Manipulation (SQL/Python)SQL
10
1
144 people solved
Nov 8, 2025
CVS Health logo
CVS Health
Easy
Data Scientist

Compute specialty spend share and top age band

You are given healthcare claims data split across member tables. Tables Assume the following schemas (types may be adapted to your SQL dialect): mem1 ...

Data Manipulation (SQL/Python)SQLPandas & Python Data
18
2
164 people solved
Oct 17, 2025
Apple logo
AppleMetaMicrosoft

Also asked at Microsoft, TCS, Google, Amazon, Bloomberg, Infosys, Adobe, Accenture, Barclays, Deloitte, Cognizant, Oracle, ZS Associates, LTIMindtree, Capgemini, HCL

Easy
Data Scientist

Write queries to compute salary and budget stats

You are given the following interview tasks. Write solutions in SQL and/or Python (pandas) as appropriate. Task 1 — Second highest salary You have a t...

Data Manipulation (SQL/Python)SQLGreedy
19
0
131 people solved
Temu logo
Temu
Easy
Data EngineerSenior+ Locked

Compute User Login Streaks

This question evaluates SQL proficiency in processing event logs for time-series analysis, encompassing date arithmetic, deduplication of same-day eve...

Coding & AlgorithmsSQL
19
0
147 people solved
Apr 3, 2026
Reddit logo
Reddit
Medium
Data ScientistSenior+

Query US-based users and most active forums

You are given user and post data for an online forum platform. Tables (schemas) Assume the following tables: users - user_id BIGINT (PK) - home_countr...

Data Manipulation (SQL/Python)SQL
14
2
234 people solved
Sep 19, 2025
Airbnb logo
Airbnb
Medium
Data Scientist

Compute C/T metrics from bookings and visits

Given two tables, compute control vs treatment (C/T) metrics, apply 24‑hour attribution, and generate a daily plot. Treat “today” as 2025‑09‑01; use t...

Data Manipulation (SQL/Python)SQLData Cleaning & Wrangling
36
0
335 people solved
Oct 13, 2025
Amazon logo
Amazon
Medium
Data Scientist

Compute join counts and window ranks

Given the following small schema and data, answer all parts precisely and justify each count/output. Tables and rows: Customers(cust_id INT PRIMARY KE...

Data Manipulation (SQL/Python)SQLIndexing & Query Performance
13
0
111 people solved
Oct 13, 2025
Meta logo
Meta
Medium
Data Scientist Locked

Count heavy callers in 7 days

This question evaluates proficiency in SQL-based data manipulation and analytics, covering joins between user and call records, aggregation and distin...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
9
0
95 people solved
Mar 24, 2026
Revolut logo
Revolut
Hard
Data Analyst

Define Ultra success and detect suspicious transactions

Assume the following relevant columns are available, and all timestamps are stored in UTC: - users(user_id BIGINT PRIMARY KEY, create_date TIMESTAMP, ...

Analytics & ExperimentationMetrics & KPIsSQL
27
0
220 people solved
Feb 23, 2026
Zoox logo
Zoox
Medium
Data Engineer

Write SQL revenue and anomaly queries

You are given two tables. Table: transactions | Column | Type | Description | |---|---|---| | transaction_id | int | Unique identifier for each transa...

Coding & AlgorithmsSQLData Quality & Validation
7
0
112 people solved
Apr 4, 2026
OpenAI logo
OpenAI
Easy
Data Scientist

Compute signup rate and retention from raw logs

Scenario You are analyzing an A/B test for a marketing campaign offering a free 1-month trial. You are given raw “upstream” tables that resemble produ...

Data Manipulation (SQL/Python)Experiment Design (A/B Testing)Metrics & KPIs
13
0
118 people solved
Oct 4, 2025
CVS Health logo
CVS Health
Medium
Data Scientist

Create and query an e-commerce schema

PostgreSQL only. 1) Create these tables with appropriate types and constraints (choose minimal correct types): products(product_id PK, name NOT NULL, ...

Data Manipulation (SQL/Python)SQL
9
0
148 people solved
Oct 13, 2025
Google logo
GoogleAmazonBloomberg
Easy
Software Engineer

Count Each Teacher’s Distinct Subjects across Departments

Problem Return teacher_id and cnt, the number of different subject_id values taught by that teacher. Teaching the same subject in several departments ...

Data Manipulation (SQL/Python)SQL
0
0
7 people solved
Google logo
Google
Medium
Data Scientist

Find most co‑purchased product pairs in SQL

Given the schema and sample data below, write ANSI-SQL to return the top 5 unordered product pairs most frequently purchased together across distinct ...

Data Manipulation (SQL/Python)SQLIndexing & Query Performance
28
1
202 people solved
Oct 13, 2025
Google logo
GoogleAmazonMicrosoftBloomberg

Also asked at Microsoft, Bloomberg

Easy
Software Engineer

Count Followers for Each Observed User

Problem Return user_id and followers_count for each user represented as user_id in Followers. The unique (user_id,follower_id) pairs prevent duplicate...

Data Manipulation (SQL/Python)SQL
0
0
5 people solved
Google logo
GoogleAmazonBloomberg

Also asked at Bloomberg, Microsoft, Meta

Easy
Software Engineer

Report Direct-Report Counts and Rounded Ages for Every Manager

Problem A manager is an employee with at least one other employee reporting directly to them. Return employee_id, name, reports_count and average_age ...

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

Write SQL for first share and closest collaborator

You are given event data about users viewing design files. Assume the following tables: - files(file_id, creator_id) - creator_id is a VARCHAR user ...

Coding & AlgorithmsSQL
41
0
350 people solved
Jan 20, 2026
ByteDance logo
ByteDance
Medium
Data Scientist

Compare SQL counts, windows, and NULL semantics

You’re given two tables. users(id INT, country STRING, created_at DATE) rows: 1 | US | 2025-08-28 2 | US | 2025-08-30 3 | IN | 2025-08-29 4 | BR | 202...

Data Manipulation (SQL/Python)SQL
12
0
111 people solved
Oct 13, 2025
Zoox logo
Zoox
Medium
Data EngineerSenior+

Design Transaction Data Quality Checks

You own data quality for the same credit-card transaction dataset. transactions | column | type | description | |---|---|---| | transaction_id | integ...

Software Engineering FundamentalsData Quality & ValidationSQL
6
0
115 people solved
Apr 11, 2026
LinkedIn logo
LinkedIn
Easy
Data Scientist

Compute each member’s current notification status

Question You are given two tables describing LinkedIn members’ push-notification settings. Compute each member’s current notification status as of 202...

Data Manipulation (SQL/Python)SQL
17
0
194 people solved
Feb 1, 2026
Previous1...91011...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