SQL for Analytics - lesson 1 | HackIndia Skills

SQL for Analytics - lesson 1 | HackIndia Skills | HackIndia

Example

Make it queryable

Here is a weak question and a better version for a campus food ordering app.

The better version is ready for SQL because it tells you what to count and how to group it.

Weak: Are users ordering food?

Better: For users in Bengaluru, how many paid orders were placed each day from 1 Jan 2026 to 7 Jan 2026?

Metric: paid orders
Rows included: orders where status = 'paid'
Time range: 2026-01-01 to 2026-01-07
Group by: order date
Filter: city = 'Bengaluru'

Example

Start a question log

Your final project will need a short explanation of insights. A question log makes that easier.

Create a plain file in your project folder. Add one row for every question before you write the query.

File: questions.md

Question 1
Product question: Are paid orders increasing week by week?
SQL-ready question: Count paid orders by week for Jan 2026.
Metric: paid orders
Table needed: orders
Filters: status = 'paid'
Time range: 2026-01-01 to 2026-01-31
Group by: week
Why it matters: Shows whether demand is growing.
Output expected: week, paid_orders

Ask better data questions

One idea

Why this matters

Question checklist

Make it queryable

Use AI well

Avoid hidden definitions

Start a question log

Do this now

Quick check