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
Roku logo
Roku
Medium
Data Scientist

Write SQL for profit, growth, retention

Write ANSI-SQL (PostgreSQL preferred) for the tasks below. Assume all timestamps are UTC and that "today" = 2025-09-01. Schema: - products(product_id ...

Data Manipulation (SQL/Python)SQLBusiness Case Analysis
10
0
158 people solved
Oct 13, 2025
Meta logo
Meta
Medium
Data Scientist

Compute multi-account actives and unread coverage

You have two tables. Table: notifications +--------+------------+------------+-------------------+--------+ | userid | ds | time | notification_type |...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
6
0
53 people solved
Oct 13, 2025
LinkedIn logo
LinkedIn
Medium
Data Scientist

Count Article Types Viewed

Count Article Types Viewed You are given article view events and article metadata. Table 1: article_views — one row per article view event. | Column |...

Data Manipulation (SQL/Python)SQLUser Behavior & Funnels
14
0
124 people solved
Aug 3, 2025
Capital One logo
Capital One
Medium
Data Scientist

Reconcile ledgers with SQL/Python and late events

You own a daily ETL + reconciliation job between two financial ledgers. Late postings (“delay time”) up to 48 hours are common. Schema: - payments_raw...

Data Manipulation (SQL/Python)SQLData Quality & Validation
7
0
142 people solved
Oct 13, 2025
Meta logo
Meta
Medium
Data Scientist

Write SQL to compute shop visibility share

Assume today is 2025-09-01. Compute the top 3 shops by average daily visibility share over the last 7 days (2025-08-26 to 2025-09-01, inclusive) for U...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
5
0
91 people solved
Oct 13, 2025
Google logo
Google
Medium
Data Scientist

Write SQL/Python for messy event data

Using the schema and sample data below, write: (1) a single SQL query to compute daily metrics for the local date 2025-09-01 in America/Los_Angeles, a...

Data Manipulation (SQL/Python)SQLPandas & Python Data
12
0
86 people solved
Oct 13, 2025
Axon logo
Axon
Hard
Software Engineer

Design an e-commerce analytics warehouse

Design an Analytics Warehouse for an E‑commerce Platform Context An e‑commerce platform exposes the following user-facing services: - Item search - It...

Analytics & ExperimentationWarehouse & Lakehouse ArchitectureData Ingestion & CDC
12
0
127 people solved
Sep 6, 2025
Google logo
Google
Medium
Data EngineerIntern

Write SQL and merge linked lists

The technical interview included two coding-style tasks: a SQL analytics query and merging two sorted linked lists. Constraints & Assumptions - For SQ...

Coding & AlgorithmsSQLLinked Lists
9
1
150 people solved
Mar 9, 2025
Airwallex logo
Airwallex
Medium
Data Scientist

Compute Moderation View Metrics

Question You are working on a content moderation analytics problem. You have two tables. Table 1: content_views (one row per user / post / day) - user...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
23
0
191 people solved
Nov 14, 2025
Meta logo
Meta
Medium
Data ScientistSenior+

Compare Average Survey Ratings of New and Tenured Users in SQL

An app logs survey impressions and responses in a survey table and each user's registration in a users table. Compare the average survey rating of new...

Data Manipulation (SQL/Python)SQL
0
0
1 people solved
Sep 14, 2026
Meta logo
Meta
Easy
Data Scientist Locked

Convert multi-currency revenue to USD totals

This question evaluates a candidate's competency in converting multi-currency revenue into USD totals by aligning event dates with FX rates, handling ...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
4
0
56 people solved
Feb 16, 2026
Capital One logo
Capital One
Medium
Data Scientist

Write SQL to find top net-revenue products

Using the sample schema and data below, write a single SQL query that returns, for the last 7 days relative to today (use today = 2025-09-01, so the w...

Data Manipulation (SQL/Python)SQL
7
0
97 people solved
Oct 13, 2025
Meta logo
Meta
Medium
Data Scientist

Calculate Total Revenue in USD Using SQL Query

ads_revenue +---------+------------+---------+----------+ | ad_id | country | revenue | currency | +---------+------------+---------+----------+ ...

Data Manipulation (SQL/Python)SQL
102
1
222 people solved
Aug 4, 2025
Meta logo
Meta
Medium
Data Scientist

Define and compute shop visibility in SQL

You own the 'shop visibility' KPI for a marketplace. Define a precise metric and write SQL to compute it over the last 7 days (use today = 2025-09-01,...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
8
0
88 people solved
Oct 13, 2025
Meta logo
Meta
Medium
Product Analyst Locked

Write SQL for call metrics

This question evaluates a candidate's competency in SQL-based data manipulation and analytics, specifically aggregations, JOINs across relational tabl...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
5
0
60 people solved
Mar 19, 2026
Meta logo
Meta
Medium
Data ScientistSenior+

Survey Response Rate per Impression and per Unique User in SQL

An app shows short in-app surveys to its users, and users who answer give a rating from 1 to 5. Every time a survey is shown and every time a user ans...

Data Manipulation (SQL/Python)SQL
0
0
1 people solved
Sep 14, 2026
Meta logo
Meta
Medium
Data Scientist Locked

Find least active countries

This question evaluates proficiency in SQL-based data manipulation and analytics, focusing on time-based filtering, distinct aggregation, grouping, th...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
5
1
54 people solved
Feb 22, 2026
Yahoo logo
Yahoo
Easy
Data ScientistSenior+

Feed Module Impressions, Clicks and CTR on Web Platforms Over a 7-Day Window

A news portal's homepage is made of content modules, and a daily traffic table records how often each article was shown and clicked in each module on ...

Data Manipulation (SQL/Python)SQL
0
0
1 people solved
Sep 6, 2026
ByteDance logo
ByteDance
Hard
Data Scientist

Advertisers Active in Both the Current and Previous Week from an Ads Activity Log

An advertising platform logs every action advertisers take in its ads-management tool in a table named ttam_logger. Besides the event time and the adv...

Data Manipulation (SQL/Python)SQL
0
0
1 people solved
Sep 7, 2026
Amazon logo
Amazon
Medium
Data Scientist

Select Top Customers Using Transaction Data Filters

transactions +----+---------+------------+--------+ | id | user_id | order_date | amount | +----+---------+------------+--------+ | 1 | 101 | 202...

Data Manipulation (SQL/Python)SQL
255
1
788 people solved
Aug 4, 2025
Previous1...131415...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