READ. UNDERSTAND. PRACTICE.
Prepare for your next interview.
Explore algorithm tutorials, coding and system design questions, interview experiences, and computer science study guides.
20,926 resources · Page 95 of 872
Coding questions · Meta
Analyze Mobile Promo Orders with SQL Query and Metrics
This question evaluates SQL data-manipulation and analytical competencies, including filtered joins, conditional aggregation, date-window filtering, and business-metric design to measure promotional performance on mobile orders.
Coding questions · Amazon
Analyze Monthly Prime vs Non-Prime Sales and Price Buckets
This question evaluates data manipulation and analytics competencies, including SQL time-based aggregation and segmentation as well as practical use of Python (pandas) for dynamic price-bucketing and percentage calculations.
Coding questions · Meta
Analyze New Shops' Activity Compared to Existing Ones
This question evaluates a data scientist's skill in data manipulation, time-series aggregation, cohort analysis, and metric design using SQL or Python to quantify shop visibility via page view counts.
Coding questions · Two Sigma
Analyze NYC taxi trips efficiently over last 7 days
This question evaluates proficiency in time-series filtering, relational joins, grouped aggregations (median and high-percentile calculations), numeric stability of percentile methods, and performance-aware vectorized data manipulation using SQL or pandas.
Coding questions · Meta
Analyze Oculus App Engagement with SQL Queries
This question evaluates proficiency in SQL-based data manipulation and aggregation, time-window filtering, percentage calculations, and the application of basic statistical hypothesis testing for comparing user engagement across categories.
Coding questions · DoorDash
Analyze Order Spending Patterns Across Cities Using SQL
This question evaluates proficiency with SQL window functions, time-aware row-level analytics, and the ability to compute intra-group rankings and prior-row comparisons on order data.
Coding questions · Shopify
Analyze Pirate Theme Usage Growth Over Time
This question evaluates a candidate's ability to perform SQL-based data manipulation and time-series analysis, emphasizing joins, aggregation, time-bucketing, and definition of growth metrics to measure feature adoption.
Coding questions · TikTok
Analyze Posting Behavior by Cohort and Date
This question evaluates a candidate's ability to perform cohort-based user attribution and time-series aggregation, specifically assigning users to acquisition cohorts by their first activity and computing total posts and distinct active users by date.
Coding questions · Meta
Analyze Recent Calling Behavior in France Using SQL
This question evaluates SQL data-manipulation competencies such as time-window filtering, joins between event and user tables, aggregation and deduplication logic, set operations (UNION vs UNION ALL), and calculation of user-level percentages from event-level data.
Coding questions · Roblox
Analyze Recent Orders Dataset with Python/pandas
This question evaluates proficiency in data manipulation and aggregation using Python/pandas, including extracting per-user maximums, computing overall summary statistics, and producing daily aggregates from time-stamped records.
Coding questions · Meta
Analyze Recent Post Performance Using SQL Queries
This question evaluates SQL-based data manipulation skills including joins, aggregation, temporal filtering, and audience segmentation to calculate viewing-time and reaction metrics.
Coding questions · Meta
Analyze Recent User Activity from Video Call Logs
This question evaluates proficiency in data manipulation and aggregation over event logs and user dimension tables, assessing skills in joining datasets, measuring unique interactions, and computing recent user-activity metrics using SQL or Python.
Coding questions · Meta
Analyze Recent User Engagement in Video Calls
This question evaluates competency in data manipulation and product analytics, focusing on transforming event-level call records into user-level engagement metrics using SQL or Python; the category is Data Manipulation (SQL/Python).
Coding questions · Netflix
Analyze Retention Metrics Using SQL and Python
This question evaluates proficiency in SQL time-based cohort analysis and practical Python algorithm implementation, testing retention metric computation using windowed date calculations and an efficient approach for finding two numbers whose sum is closest to zero.
Coding questions · Uber
Analyze sales with groupby
This question evaluates proficiency in data manipulation and analytics using pandas, specifically the ability to join relational tables and apply groupby aggregations to compute business metrics like total sales, average sales per order, and completion rates.
Coding questions · Amazon
Analyze Seller Compliance and Customer Purchase Patterns
This question evaluates a candidate's ability to manipulate and analyze temporal and categorical datasets, covering competencies such as event sequencing, set-based filtering, and cross-table aggregation in SQL/Python.
Coding questions · TikTok
Analyze shopping funnel with joins and windows
This question evaluates SQL-based data manipulation skills—specifically event deduplication, temporal ordering, joins, and window-function usage for multi-step funnel conversion analysis with session- and user/product-level scoping, and is categorized as Data Manipulation (SQL/Python) for a data scientist role.
Coding questions · Meta
Analyze Social Media Engagement with SQL Queries
This question evaluates SQL data-manipulation and analytics competencies, including aggregation, DISTINCT counting, joins between view and action logs, date-range filtering, and conditional metric computation from event data.
Coding questions · Meta
Analyze spend cohort and source shifts
This question evaluates data manipulation and analytical SQL/Python skills, focusing on cohort analysis, time-series aggregation, joins and filtering, and comparative spend analytics across calendar years.
Coding questions · Twitch
Analyze Streaming Data with SQL for Monthly Trends
This question evaluates proficiency in SQL time-series aggregation, date extraction and grouping across calendar months, join and conditional aggregation techniques, windowed month-over-month comparisons, and handling sparse or multi-year datasets; Category: Data Manipulation (SQL/Python); level: practical application.
Coding questions · Amazon
Analyze Top Book Sales and Unique Customer Purchases
This question evaluates proficiency in data manipulation and SQL querying, focusing on aggregation, date-based filtering, joins, and set-difference logic across transactional and catalog tables.
Coding questions · Meta
Analyze Top Call Initiators and Active French Video Callers
This question evaluates proficiency in SQL-based data manipulation and analytics—specifically aggregation, grouping, time-window filtering, and percentage calculations—by asking for the top call initiators over the last seven days and the proportion of active users in France on video calls yesterday, and is categorized under Data Manipulation (SQL/Python) for a Data Scientist role with a focus on practical application. It is commonly asked in technical interviews to assess a data scientist's ability to extract actionable engagement metrics from event logs, reason about temporal windows and population denominators, and produce accurate, explainable reporting from production-style datasets.
Coding questions · Robinhood
Analyze Transaction Flow and User Engagement Efficiently
This question evaluates proficiency in SQL joins, aggregations and window functions alongside Python data-manipulation skills to compute per-user totals, running cumulative amounts, and leaderboards of senders and receivers.
Coding questions · PayPal
Analyze Transactions and Classify by Amount in SQL
This question evaluates SQL data manipulation competencies, including aggregation, grouping vs HAVING for filtered aggregations, and conditional classification using CASE WHEN on transactional data.