╔══════════════════════════════════════════════════════════╗
║  FROM EXCEL TO SQL — Exercise File Pack                 ║
║  From Spreadsheets to Code Series — Book 2              ║
║  Waskey Press | www.waskeypress.com                     ║
╚══════════════════════════════════════════════════════════╝

SETUP
─────
1. Install DB Browser for SQLite (free): sqlitebrowser.org
2. Open DB Browser → "Open Database" → select data/company.db
3. Click "Execute SQL" tab
4. Open a starter .sql file and paste queries to run them

FOLDER STRUCTURE
────────────────
starter/     .sql scripts, one per chapter
  ch01_schema.sql         Chapter 1  — Schema Exploration
  ch02_select.sql         Chapter 2  — SELECT and Expressions
  ch03_where.sql          Chapter 3  — WHERE Filtering
  ch04_order_limit.sql    Chapter 4  — ORDER BY and LIMIT
  ch05_aggregation.sql    Chapter 5  — GROUP BY and HAVING
  ch06_joins.sql          Chapter 6  — JOINs
  ch07_subqueries.sql     Chapter 7  — Subqueries and CTEs

data/
  company.db    SQLite database (6 tables: employees, departments,
                customers, products, orders, order_items)

solutions/    Available at waskeypress.com/files

DATABASE SCHEMA (quick reference)
──────────────────────────────────
departments  (department_id, name, budget, location)
employees    (employee_id, first_name, last_name, department_id,
              title, salary, hire_date, manager_id, email, active)
customers    (customer_id, company_name, region, tier, contact_email, since)
products     (product_id, product_name, category, unit_price, stock_qty)
orders       (order_id, customer_id, order_date, status, sales_rep_id)
order_items  (item_id, order_id, product_id, quantity, unit_price, total)

CONTACT
────────
waskeypress.com/files | contact@waskeypress.com
