Start free

Interview quiz track

First 2 free Intermediate Data Analyst

Data Analyst – SQL for Analysts

Practice SQL questions commonly asked in data analyst interviews. Cover aggregations, joins, date functions, and business-focused queries. Write queries and receive feedback on correctness and approach. Ideal for data analyst interview prep. First 2 questions are free with full feedback.

  • Level Intermediate
  • Questions 12
  • data analyst
  • SQL
  • intermediate
  • interview practice

Try any track free — first 2 questions include full AI feedback. Subscribe to finish the track and unlock everything. Type or speak your answer — the first 2 questions include scoring and detailed AI feedback.

Try first 2 questions free All tracks

Sample data analyst – sql for analysts interview questions

Preview 6 questions from this track in quiz order. In the full quiz you answer one at a time — type or speak — then get a score and feedback.

  1. Write a query to find the total revenue by month.

    What a strong answer includes

    Groups by month and sums revenue.

  2. How do you calculate month-over-month growth in SQL?

    What a strong answer includes

    Uses LAG or a self-join.

  3. Write a query to find customers who have not ordered in the last 90 days.

    What a strong answer includes

    Uses a date filter or NOT EXISTS.

  4. Explain the difference between WHERE and HAVING.

    What a strong answer includes

    WHERE filters rows; HAVING filters groups.

  5. Write a query to get the average order value by customer segment.

    What a strong answer includes

    Joins and groups correctly.

  6. How do you find duplicate records in a table?

    What a strong answer includes

    Uses GROUP BY and HAVING COUNT > 1.