Trusted by 750,000+ members worldwide

Land Your DreamData Role

Practice real interview questions, simulate interviews with AI, and build portfolio projects — everything you need to walk into your next interview with confidence.

0+

Questions

0+

Free

0K+

Members

0+

Companies

Interview Success Stories From

Facebook
Google
Airbnb
Twitch
Postmates
Stripe
Amazon
Microsoft
Real Interview Questions

Practice Questions from Top Companies

Master the exact questions asked at Google, Meta, Amazon, and 200+ other companies. From coding challenges to conceptual interviews — we've got you covered.

Interview Coding Questions

1000+ real coding challenges

Practice SQL and Python coding questions with our interactive code editor. Write, run, and validate your solutions in real-time.

SQL Dialects

PostgreSQLMySQLMS SQL ServerOracle

Python Libraries

PandasPySparkPolars

Other Languages

R
Explore Coding Questions

Interview Concepts

Master non-coding interview rounds

Prepare for the full interview process with conceptual questions that test your analytical thinking, business acumen, and technical knowledge.

Question Types

System DesignProduct SenseBusiness CaseStatisticsProbabilityModelingTechnicalBehavioral
AI Evaluator

Submit your answer and get detailed AI feedback — scored on completeness, accuracy, depth, structure, and practical relevance, with specific improvement suggestions.

Explore Concept Questions
Your AI Interviewer

Simulate Real Interviews Before the Real Thing

Practice under real conditions with an AI interviewer that tracks your time and delivers detailed feedback on both your code and communication.

Online Assessment

60 min · 2 Qs

Phone Interview

90 min · 2 Qs

Onsite Interview

120 min · 3 Qs

  • Choose your role, company, and difficulty — or Quick Start instantly
  • Detailed scoring on code quality, correctness, and communication
  • Personalized AI review with actionable feedback on your code
Start Mock Interview

Mock Interview Session

Data Analyst · Google · Medium

Question 1 of 2
31:18

SMS Confirmations by FB

Find the number of phone numbers that were sent a confirmation SMS text by carrier on August 7, 2020…

Table Schema

  • carrierTEXT
  • countryTEXT
  • dsDATE
  • phone_numberBIGINT
  • typeTEXT
Postgresql
TestSubmit
Welcome to your interview! I'm your AI interviewer. Feel free to ask me for clarification on any question or if you need a hint. Let's get started!
Data Projects

Build Real Data Projects in Our Cloud Hosted Notebooks

Practice real take-home assignments from top companies. Build your data portfolio and share it directly from your Performance page — no local setup required.

  • Real take-home assignments from top tech companies
  • Cloud-hosted Python notebooks — no installation needed
  • Build and showcase your data portfolio for interviews
  • Share your work publicly from your Performance page
Explore Data Labs
AssignmentYour SolutionSolutionSolutions from UsersDiscussion
1import marimo as mo
2
3fig = create_career_analytics_dashboard()
4fig.show()
Data Career Analytics Dashboard
Reactive • Git-friendly • AI-native
Learn Free

Structured Learning Paths for SQL & Python

Go from foundations to interview-ready with our comprehensive free learning paths. Each path covers everything you need for data interviews — with lessons, practice questions, and hands-on projects.

  • Comprehensive SQL: foundations to window functions
  • Comprehensive Python: pandas, data wrangling, and interview patterns
  • 36 lessons and 160+ practice questions per path
  • Completely free — no premium required

Comprehensive SQL

Master SQL from foundations to advanced window functions. 6 modules covering everything you need for data analyst interviews.

8–12 weeks6 modules36 lessons160+ questions
  • 1

    SQL Foundations

    8 lessons · 4 hr 30 min

  • 2

    Aggregating & Grouping Data

    6 lessons · 3 hr 25 min

  • 3

    Working with Multiple Tables

    8 lessons · 4 hr 5 min

  • 4

    Subqueries & CTEs

    4 lessons · 2 hr 20 min

  • 5

    Date, Time & Text Functions

    5 lessons · 3 hr 20 min

  • 6

    Window Functions

    5 lessons · 2 hr 55 min

AI StrataTools

AI StrataTools run your code — so you don't run into errors

Validate and optimize your Python and SQL by running it in real environments, delivering reliable results and reducing AI hallucinations.

Run Code

Run your code in real environment

Try it

Sample Dataset

Generate a sample dataset to test your code

Try it

Optimize Code

Fix and optimize your SQL and python code

Try it
Try AI StrataTools

Transformed Code:

sql
SELECT
    customer_id,
    order_date,
    ROW_NUMBER() OVER (
        PARTITION BY customer_id
        ORDER BY order_date DESC
    ) AS rn
FROM orders;

Loved by Data Scientists

Join thousands who landed jobs at top tech companies

StrataScratch has been super helpful. I started with barely being able to finish an easy SQL query to no problem solving most of the medium level in just a few days.

K

Kyle

Twitch

Twitch logo

StrataScratch is hands down the best platform if you are preparing for or am working as a data analyst/scientist/engineer. Happy to share that I have gotten an offer from Amazon as a Data Analyst.

T

Triman

Amazon

Amazon logo

I really wanted to get into data analytics and data science but never really understood the importance of SQL. The questions are really very realistic and I was asked similar questions in my coding rounds.

HR

Hemant R

Credit Karma

Credit Karma logo

SQL is something that is super important and plays a key role in Data Analysis. I used to practice 2-3 SQL problems everyday. The discussion forum and solution with clear understanding cleared my barriers.

V

Vikram

Microsoft

Microsoft logo

StrataScratch and the community really helped me prep for the interview — I ended up getting the Data Scientist internship!

J

Joe

Microsoft

Microsoft logo

StrataScratch is awesome! It's the first place I found that allows you to use python in addition to SQL. The Facebook questions were quite similar to the ones that I saw in my interview today.

R

Ryan

Facebook

Facebook logo

Level Up Your Data Skills

Free guides, tutorials, and resources from our team

How To Pass Data Interviews for Machine Learning Engineer Roles

How To Pass Data Interviews for Machine Learning Engineer Roles

How do you get a machine learning engineer job? By passing the interviews, obviously. In this article, we deal with exactly that by detailing how to prepare.

Tihomir Babic

Tihomir Babic -

math degree for data science

You Don’t Need to Be a Math Genius for Data Science

Learn the truth about data science interviews and how deep you actually need to go into maths.

Tihomir Babic

Tihomir Babic -

Your Next Interview Is Closer Than You Think

Start practicing with real interview questions today. No credit card required.