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

Compute adoption, latency, and cross-region transactions

Invented schema: users(user_id INT PRIMARY KEY, user_region STRING, adopted_at TIMESTAMP NULL) transactions(txn_id INT PRIMARY KEY, user_id INT, txn_t...

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

Design Schema for Accurate Subscription State Tracking

subscription_events +----------+---------------------+-----------+-----------+ | user_id | event_ts | event_type| plan_type | +----------+...

Data Manipulation (SQL/Python)SQLDimensional Modeling
151
0
513 people solved
Aug 4, 2025
Microsoft logo
Microsoft
Medium
Data Scientist

Find common friends from directed edges

You have a directed edge list that records who followed whom. A mutual “friendship” exists only if both directions appear (A→B and B→A). Schema and sa...

Data Manipulation (SQL/Python)GraphsSQL
18
0
127 people solved
Oct 13, 2025
Rbcroyalbank logo
Rbcroyalbank
Easy
Data EngineerIntern

Explain pandas and SQL basics

You are interviewing for a Data Engineer co-op/intern role. Answer the following short technical questions. Python / pandas: 1. What is the difference...

Data Manipulation (SQL/Python)SQLPandas & Python Data
11
0
79 people solved
Jan 14, 2026
EliseAI logo
EliseAI
Medium
Data Scientist

Lease Renewal Prediction and Non-Renewal Reason Categorization Take-Home

This take-home gives you 24 hours of work, followed by a 30-minute presentation that serves as a research deep-dive on your approach. The objective is...

Machine LearningSupervised LearningFeature Engineering
2
0
23 people solved
Nov 2, 2025
Meta logo
Meta
Medium
Data Scientist

Compute feed ad frequency and retention in SQL

Assume today is 2025-09-01. Schema and tiny samples: feed_impressions(impression_id, user_id, impression_time, content_type, feed_position, session_id...

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

Aggregate User Activity, Fit Regression, Interpret Coefficients

user_metrics +----------+------------+---------+--------+-----------+ | user_id | activity_dt| variant | clicks | purchases | +----------+-----------...

Data Manipulation (SQL/Python)Regression & Statistical ModelingSQL
119
0
396 people solved
Jul 12, 2025
DoorDash logo
DoorDash
Hard
Analytics Engineer

Compute Fitness App DAU

You are working on a fitness app. The schema is: users(user_id BIGINT, signup_ts TIMESTAMP, timezone VARCHAR, is_test_user BOOLEAN) and app_events(eve...

Data Manipulation (SQL/Python)SQL
16
1
165 people solved
Oct 12, 2025
Meta logo
Meta
Medium
Data Scientist Locked

Write SQL for multi-account metrics

This question evaluates proficiency in SQL for multi-table aggregation, grouping, joins, and conditional counting within a user-account-notification s...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
10
1
80 people solved
Mar 16, 2026
Meta logo
Meta
Medium
Data Scientist

Compute seller counts and vehicle share

You are given two tables: 1. listing_interactions - buyer_id BIGINT - seller_id BIGINT - event_date DATE - product_id BIGINT - listing_...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
9
2
76 people solved
Jan 5, 2026
Intuit logo
Intuit
Medium
Software Engineer

Aggregate transactions by status and failure reasons (SQL)

You are given a table transactions with (at least) the following columns: - transaction_id (unique identifier) - status (e.g., SUCCESS, FAILED, PENDIN...

Software Engineering FundamentalsSQLData Cleaning & Wrangling
12
0
137 people solved
Oct 13, 2025
Shopify logo
Shopify
Medium
Data Scientist AI

Analyze Pirated Theme Usage Impact

An e-commerce platform lets shops install marketplace themes. Some themes are paid, and a shop should have a valid purchase/license before using a pai...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
23
0
138 people solved
Apr 28, 2026
Booking.com logo
Booking.com
Medium
Software Engineer

Compare heap, stack, Protobuf, gRPC, SQL, CI/CD

Compare heap, stack, Protobuf, gRPC, SQL, CI/CD Technical/Phone Screen: Core Systems and Data Concepts You are interviewing for a Software Engineering...

System DesignMemory ManagementAPI Design
33
0
210 people solved
Jul 29, 2025
Meta logo
Meta
Medium
Data Scientist

Write SQL for CTR and revenue

Write SQL for the following two tasks. Problem 1: CTR during peak vs. non-peak hours You are given three tables: - ads(ad_id BIGINT, advertiser_id BIG...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
12
1
81 people solved
Jan 3, 2026
Capital One logo
Capital One
Medium
Data Scientist

Write SQL using joins and window functions

SQL Coding: Rank within Groups with Joins You are given two tables: accounts - account_id (string) - customer_id (string) - segment (string) — e.g., "...

Coding & AlgorithmsSQL
40
1
275 people solved
Mar 1, 2026
Meta logo
Meta
Medium
Data Scientist

Calculate posts per DAU by country today

Given two tables: - user_activity(user_id INT, activity_date DATE, country STRING, dau_flag TINYINT CHECK(dau_flag IN (0,1))) - composer(user_id INT, ...

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

Find multi-account buckets and unread rate

You are analyzing a product in which one user can own multiple accounts. Use the following schema: Table: accounts - account_id BIGINT - user_id BIGIN...

Data Manipulation (SQL/Python)SQLMetrics & KPIs
10
1
65 people solved
Jan 21, 2026
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
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
Previous1...121314...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