SELECT all customers and understand their basic attributes
Hey — welcome aboard! Before standup can you pull up `dim_customers` and grab the first 10 rows? Just want to see what we're working with before we start digging in. All columns is fine.
| Column | Type | Key |
|---|---|---|
| customer_id | INT | PK |
| first_name | TEXT | |
| last_name | TEXT | |
| TEXT | ||
| signup_date | TEXT | |
| city | TEXT | |
| state | TEXT | |
| age | INT | |
| gender | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
The customer table is a `dim_` table. Alex wants a quick preview — just the first handful of rows, not the whole 500-row dump.
You need all 9 columns: customer_id, first_name, last_name, email, signup_date, city, state, age, gender
Make sure you're using `LIMIT 10` — without it you'll load all 500 rows. The query is just `SELECT * FROM dim_customers LIMIT 10`