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

Compute percent of active users with 50+ calls

Problem You work on a Messenger-like app. You want to measure how many active users in Great Britain (GB) today have been heavy callers recently. Tabl...

Data Manipulation (SQL/Python)SQL
10
1
135 people solved
Dec 8, 2025
Meta logo
Meta
Medium
Data Scientist

Write dating profile report with final reviews

Today is 2025-09-01. You need a daily dating-profile quality and engagement report that only includes profiles whose latest version has a final approv...

Data Manipulation (SQL/Python)SQLData Quality & Validation
10
0
73 people solved
Oct 13, 2025
TikTok logo
TikTok
Medium
Data Scientist

Compute CTR drop with exclusions

Assume today = 2025-09-01. Using ad delivery logs, find advertisers whose CTR in the last 7 days (2025-08-25 to 2025-08-31) dropped by at least 20% re...

Data Manipulation (SQL/Python)SQL
10
0
147 people solved
Oct 13, 2025
Meta logo
Meta
Easy
Analytics Engineer Locked

Compute daily active ads

This question evaluates proficiency in data manipulation and analytics engineering, focusing on time-based event aggregation, status-based filtering, ...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
2
0
46 people solved
Feb 15, 2026
TCS logo
TCS
Hard
Data Scientist

Compare Tableau blending, joins, and filters

Tableau Integration Exercise: Joins vs Blends, Filters, and Order of Operations Data You have two sources. Primary (Orders) - Columns: OrderID, State,...

Analytics & ExperimentationBI & Reporting SystemsSQL
16
0
127 people solved
Oct 13, 2025
The New York Times logo
The New York Times
Medium
Data Analyst

Write SQL for content view metrics by device

Write SQL for content view metrics by device You are a reporting analyst for a news subscription product. You have a fact table of page/content view e...

Data Manipulation (SQL/Python)SQL
5
0
84 people solved
Mar 1, 2022
Medium
Data ScientistSenior+

Diagnose zero IE uploads with SQL

On 2025‑09‑01 ('today'), the dashboard shows image uploads for Internet Explorer (IE) dropped to zero. Write SQL to (a) determine if this is a technic...

Data Manipulation (SQL/Python)DebuggingMetric Diagnostics
3
0
55 people solved
Oct 13, 2025
Meta logo
Meta
Medium
Data Scientist

Find posts with >60s unconnected viewing time

Context You work on a social app where users can view posts. A view can be from a connected user (viewer is friends/connected with the post author) or...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
4
1
75 people solved
Jul 28, 2025
Meta logo
Meta
Medium
Data Scientist Locked

Analyze spend and creation-source shifts

This question evaluates a data scientist's competency in SQL-based data manipulation, time-series aggregation, joins, and metric computation for analy...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
9
0
70 people solved
Mar 1, 2026
PayPal logo
PayPal
Medium
Data Scientist

Write conditional aggregates with CASE WHEN

Write conditional aggregates with CASE WHEN Write a query that produces conditional aggregates using CASE WHEN (e.g., counts of approved vs declined t...

Data Manipulation (SQL/Python)SQLCode Quality & Maintainability
6
0
90 people solved
Jul 31, 2025
Instacart logo
Instacart
Medium
Software Engineer

Compute immediate delivery percentage

Compute immediate delivery percentage LeetCode 1173. Immediate Food Delivery I – Write an SQL query to calculate the percentage of immediate (same-day...

Coding & AlgorithmsSQL
12
0
153 people solved
Aug 4, 2025
TikTok logo
TikTok
Medium
Data Scientist

SQL Queries and Analysis on Bad Advertisers

Scenario You are on the analytics team at TikTok and need to analyze the presence of bad content in ads and identify problematic advertisers. Question...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
15
0
113 people solved
Jun 29, 2025
Shopify logo
Shopify
Easy
Data Scientist Locked

Compute pirated-theme usage and revenue loss

This question evaluates SQL data manipulation and time-series analytics skills, focusing on interval overlap logic, aggregation of distinct entities, ...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
8
0
66 people solved
Jan 17, 2026
Intuit logo
Intuit
Medium
Data Scientist Locked

Build 30-day retention cohort table

This question evaluates SQL-based cohort analysis, 30-day retention metric calculation, handling of right-censoring, and data-quality reasoning within...

Analytics & ExperimentationSQLSegmentation & Cohort Analysis
18
0
141 people solved
Oct 13, 2025
Medium
Data Scientist

Write SQL to analyze response accuracy and speed

You are given response-level data for an online assessment with sections verbal/design/analytics and verbal subtypes grammar/vocab/tense/other. Using ...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
3
0
61 people solved
Oct 13, 2025
Akuna Capital logo
Akuna Capital
Medium
Software Engineer

Identify false MySQL foreign key statement

MySQL: Which of the following statements is false? A) A column might have a foreign key reference to itself. B) MySQL supports foreign key references ...

Data Manipulation (SQL/Python)
13
0
116 people solved
Sep 6, 2025
Meta logo
Meta
Medium
Data Scientist

Compute view prevalence from views and labels

Given the tables below, write SQL to compute view prevalence of violating content. Use “today” = 2025-09-01 and report the last 7 days (2025-08-26 to ...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
10
0
76 people solved
Oct 13, 2025
Meta logo
Meta
Medium
Data Scientist

Analyze Seller Activity and Vehicle Listing Interactions

Analyze Seller Activity and Vehicle Listing Interactions listing_interaction +-----------+-----------+------------+------------+----+ | buyer_id | se...

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

Percentage of French Daily Active Users Who Were on a Video Call Yesterday

A product logs one-to-one video calls and keeps a daily snapshot of every user. Write a query that returns the percentage of daily active users from F...

Data Manipulation (SQL/Python)SQL
0
0
2 people solved
Apr 26, 2024
Previous1...181920Next
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