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
Apple logo
Apple
Hard
Data Scientist

Autocorrect Enablement Rate by Keyboard Language for One Day

A device maker's keyboard team logs daily keyboard usage and each device's keyboard settings. For the day 2025-06-02, compute the autocorrection enabl...

Data Manipulation (SQL/Python)SQL
0
0
3 people solved
May 2, 2026
Rbcroyalbank logo
Rbcroyalbank
Easy
Data EngineerSenior+

Explain Pandas and SQL Basics

You are interviewing for a Data Engineer internship. Answer the following short data-manipulation questions: 1. In pandas, what is the difference betw...

Data Manipulation (SQL/Python)SQLPandas & Python Data
6
0
57 people solved
Feb 17, 2026
Amazon logo
Amazon
Medium
Data Scientist

Verify subscriptions and analyze orders with SQL/Python

You are given two tables. Write SQL and Python (pandas) to answer the sub-questions precisely, handling edge cases, ties, and missing data. Schema - s...

Data Manipulation (SQL/Python)SQLData Cleaning & Wrangling
16
0
109 people solved
Oct 13, 2025
Salesforce logo
Salesforce
Medium
Software Engineer Locked

Write SQL for top spender and non-spenders

This question evaluates SQL querying skills including aggregation and grouping, date/time windowing for previous-calendar-month calculations, joins an...

Software Engineering FundamentalsSQL
9
0
85 people solved
Jan 22, 2026
ByteDance logo
ByteDance
Medium
Data Scientist

Non-US Countries With at Least 1,000 Video-Watch Events in a Date Range

A company that runs several video apps logs user activity in an event table. For a reporting period, find every country other than the United States i...

Data Manipulation (SQL/Python)SQL
0
0
1 people solved
Aug 24, 2026
Uber logo
Uber
Medium
Product Manager

Session Lengths by Country: Long-Session Average, 5-Minute Histogram, Similar Pairs

You have a table of user sessions with one row per session and two columns: | Column | Meaning | |---|---| | country | The user's country | | session_...

Data Manipulation (SQL/Python)SQLPandas & Python Data
0
0
7 people solved
Feb 17, 2025
Amazon logo
Amazon
Medium
Software Engineer

Compute unique visitors per department from clicks

Given tables Products(product_id, department, category, subcategory) where department > category > subcategory form a hierarchy, and ClickLog(user_id,...

Data Manipulation (SQL/Python)SQL
8
0
85 people solved
Sep 6, 2025
Amazon logo
Amazon
Medium
Data Scientist

Write SQL window functions for D7 retention

Assume you have the following tables (timestamps are in UTC). 1) game_sessions - user_id (STRING) - session_start_ts (TIMESTAMP) - country (STRING) Ea...

Data Manipulation (SQL/Python)SQL
16
2
230 people solved
Nov 4, 2025
Nextdoor logo
Nextdoor
Hard
Data Engineer

Write SQL for basic user metrics

You are given a simplified schema for a fictional social app called Nextagram: - users(user_id PK, username, created_at TIMESTAMP) - follows(follower_...

Coding & AlgorithmsSQL
6
0
108 people solved
Feb 8, 2026
Hinge logo
Hinge
Easy
Data Engineer

Model course sales for a sports venue chain, query it, and track manager history

A chain of sports venues sells classes at each of its venues, and the operations team wants to see sales by venue and by class. You receive three sour...

Data Manipulation (SQL/Python)Dimensional ModelingSQL
0
0
3 people solved
May 12, 2026
Coinbase logo
Coinbase
Easy
Data ScientistSenior+

Write SQL for 30-day activity and D7 retention

You are given two tables. Table: trades - user_id (BIGINT) - trade_time (TIMESTAMP) — timestamp of the trade - volume (NUMERIC) - asset (TEXT) Table: ...

Data Manipulation (SQL/Python)SQLSegmentation & Cohort Analysis
11
0
82 people solved
Feb 6, 2025
Meta logo
Meta
Medium
Data Scientist

Compute cohort GMV and payer rate with edge cases

You are given the following schema (timestamps are UTC): users(user_id INT, country STRING, created_at TIMESTAMP) events(user_id INT, event_ts TIMESTA...

Data Manipulation (SQL/Python)SQLSegmentation & Cohort Analysis
15
0
123 people solved
Oct 13, 2025
OneMain Financial logo
OneMain Financial
Medium
Data Scientist

Write SQL for cohort retention and ARPU

Using PostgreSQL, compute monthly signup cohort D30 retention and 30-day ARPU. Cohort month = date_trunc('month', signup_date). D30 retention = users ...

Data Manipulation (SQL/Python)SQLSegmentation & Cohort Analysis
4
1
93 people solved
Oct 13, 2025
Airwallex logo
Airwallex
Medium
Data ScientistSenior+

Funnel SQL: Cohort Signup Rate, Campaign KYC Submit Rates and Monthly Visitor Growth

A fintech company that serves businesses tracks its website acquisition funnel in three tables. A visitor arrives in a session, sometimes through a ma...

Data Manipulation (SQL/Python)SQLSegmentation & Cohort Analysis
0
0
1 people solved
Aug 15, 2026
Rbcroyalbank logo
Rbcroyalbank
Easy
Data EngineerSenior+

Differentiate pandas objects and SQL filters

Python (pandas) 1. What is the difference between a pandas Series and a pandas DataFrame? - Discuss structure (1D vs 2D), indexing, column labels, ...

Data Manipulation (SQL/Python)SQLPandas & Python Data
4
1
67 people solved
Feb 8, 2026
Shopify logo
Shopify
Hard
Data Scientist

Calculate Pirated Usage and Revenue Loss

You are analyzing theme piracy on an e-commerce platform. Assume the analysis window is 2023-01-01 through 2023-12-31, all timestamps are stored in UT...

Data Manipulation (SQL/Python)SQL
24
0
234 people solved
Jan 12, 2026
Meta logo
Meta
Medium
Data Scientist Locked

Calculate CTR and ad revenue

This question evaluates proficiency in data manipulation and analytics, specifically metric calculation (CTR) and multi-currency revenue aggregation, ...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
10
2
105 people solved
Jan 25, 2026
Amazon logo
Amazon
Medium
Data Scientist

Find top-spend categories per customer with ranking

Using the schema and sample data below, write a single ANSI SQL query (CTEs allowed; no temp tables) that returns, for each customer, their top 2 prod...

Data Manipulation (SQL/Python)SQL
3
0
66 people solved
Oct 13, 2025
Coinbase logo
Coinbase
Medium
Data ScientistSenior+

Compute 30-day power users and 7-day retention

Compute 30-day power users and 7-day retention You are interviewing for a Product/Risk Data Scientist role at a crypto exchange. Assume all timestamps...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
9
4
97 people solved
Mar 25, 2025
DoorDash logo
DoorDash
Medium
Data Scientist

Measure Late Deliveries and Identify Top Delayed Restaurants

orders +----------+---------+--------------+---------------------+-------------------------+-----------------------+ | order_id | user_id | restaurant...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
10
1
85 people solved
Aug 4, 2025
Previous1...151617...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