Keyword Bidding

Booking Regression

Encoding Categorical Features

Significance Time Series

Assumptions of Linear Regression

Get the top 3 highest employee salaries by department

Top Three Salaries

Last Transaction

Write a query to select the top 3 departments with at least ten employees and rank them according to the percentage of their employees making over 100K in salary.

Employee Salaries

Fractional Shares

Estimating D

Experiment Validity

Subscription Overlap

Why Do We Need Time Series Models?

Create and write queries for health metrics for stack overflow 

Community Health Metrics

Select the 2nd highest salary in the engineering department

2nd Highest Salary

Promoting Instagram

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Hundreds of Hypotheses

Lasso vs Ridge

Write a query to randomly sample a row from a big table.

Random SQL Sample

Instagram TV Success

Write a query to get the number of customers that were upsold

Upsell Transactions

Say you are given a dataset of perfectly linearly separable data. What would happen when you run logistic regression?

Perfectly Separable

Youtube Recommendations

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

Write a function to create a single dataframe with complete addresses in the format of street, city, state, zip code.

Complete Addresses

Type-ahead Search

Closest SAT Scores

Write a function to return a dataframe containing every transaction with a total value of over $100.

Over 100 Dollars

Job Recommendation

Revenue Retention

Raining in Seattle

How would you build a model to detect if a post on a marketplace is talking about selling a gun?

Detecting Firearm Sales

This problem involves finding the first non-repeating character in a given string. The solution involves iterating over the string and keeping track of the frequency of each character. The first character that has a frequency of 1 is the first non-repeating character.

Find the First Non-Repeating Character in a String

Compute Deviation

Write a function to select only the rows where the student's favorite color is green or red and their grade is above 90.

Good Grades and Favorite Colors

New Partner Card

Email Blast

Parents Joining Teens

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Boarding Times Bias

First to Six

Distance Traveled

Write a query that returns all neighborhoods that have 0 users.

Empty Neighborhoods

Coefficients of Logistic Regression

First Touch Attribution

Facebook Stories

Write a function friendship_timeline to generate an output that lists the pairs of friends with their corresponding timestamps of the friendship beginning and then the timestamp of the friendship ending. 

Friendship Timeline

Write a function to get a sample from a standard normal distribution.

Normal Distribution Sample

Random Bucketing

How would you identify supply and demand mismatch in a ride sharing market place?

Demand Metrics

Amateur Performance

Alphabet Sum

Impression Reach

Distribution of 2X - Y

Given an integer N, write a function that returns all of the prime numbers up to N

Prime to N

Stranded Miner

Mouse Search

Netflix Retention

How do we give each rejected applicant a reason why they got rejected?

Rejection Reason

Threaded Comments

Customer Orders

Using R Squared

What is the difference between the Z and t tests?

Z and t-Tests

How would you investigate a decline in the average number of comments per user?

Decreasing Comments

Rolling Bank Transactions

Given two sorted lists, write a function to merge them into one sorted list.

Merge Sorted Lists

How would you find out if an increase in user conversion rates after a new email journey is casual or just part of a wider trend?

Causal Email Journey 

Bank Fraud Model

Download Facts

Paired Products

Manager Team Sizes

Cumulative Distribution

Monthly Customer Report

Greatest Common Denominator

Changing Composer

Given that it is raining today and that it rained yesterday, write a function to calculate the probability that it will rain on the nth day after today.

Rain in N Days

Write a query to get the current salary for each employee after an ETL error.

Employee Salaries (ETL Error)

Variable Error

Write a SQL query to create a histogram of the number of comments per user in the month of January 2020.

Comments Histogram

Button AB Test

Find the missing integer from a array of consequtive integers

Find the Missing Number

How do we go about selecting the best 10,000 customers for the pre-launch?

Pre-Launching Shows

Write a query to create a metric that can validate and rank the queries by their search result precision.

Search Ratings

Poker Pair

Find how much overlapping jobs are costing the company

Nightly Job

Write a SQL query to find the average number of right swipes for different ranking algorithms.

Swipe Precision

Given a stream of numbers, select a random number from the stream.

Random Number

Total Salary

Random Seed Function

500 Cards

Reducing Error Margin

One Million Rides

Missing Housing Data

Unbiased Estimator

Spam Classifier 

Post Composer Drop

Comparing Search Engines

Reconstruct the path of a trip so that the trip tickets are in order.

Scrambled Tickets

How would you analyze how the feature is performing?

Recruiting Leads

Determine whether there exists a permutation of an input string that is a palindrome.

Title	Score	Tags	Company	Difficulty	Success This is the total number of accepted submissions divided by the total number of submissions.
Ride-Sharing App Schema	1		Locked	Medium	N/A	Save question Mark as completed
Dynamic Demand Pricing	2		Locked	Medium	N/A	Save question Mark as completed
Retailer Data Warehouse	7		Locked	Medium	N/A	Save question Mark as completed
Modifying a Billion Rows	18		Locked	Medium	N/A	Save question Mark as completed
Average Unique Counts	3		Locked	Medium	75%	Save question Mark as completed
Payment Data Pipeline	4		Locked	Medium	N/A	Save question Mark as completed
Listing Bookings Aggregation	3		Locked	Medium	81%	Save question Mark as completed
Relational Migration	2		Locked	Medium	N/A	Save question Mark as completed
Digital Classroom System Design	5		Locked	Medium	N/A	Save question Mark as completed
Multi-Reaction	5		Locked	Medium	N/A	Save question Mark as completed
Yelp-like System	3		Locked	Medium	N/A	Save question Mark as completed
Crossing Bridges	10		Locked	Medium	N/A	Save question Mark as completed
Address Schema	7		Locked	Medium	N/A	Save question Mark as completed
Podcast Search	2		Locked	Hard	N/A	Save question Mark as completed
Restaurant Recommender	5		Locked	Medium	N/A	Save question Mark as completed
Subway Machine Learning Model	0		Locked	Easy	N/A	Save question Mark as completed
Swipe Payment API	0		Locked	Easy	N/A	Save question Mark as completed
Generating Discover Weekly	5		Locked	Hard	N/A	Save question Mark as completed
International e-Commerce Warehouse	3		Locked	Medium	N/A	Save question Mark as completed
Creating Companies Table	1		Locked	Medium	N/A	Save question Mark as completed

Interview Questions

Quick filters

Top Companies

Question Tags