Quick Start Guide

Before writing ANY SQL query:

1. Read metadata files (MANDATORY):

   • data/metadata/financial_summary_by_student.yaml
   • data/metadata/financial_summary_by_student_sample_data.csv

2. Identify query pattern from user's question:

   • "How many..." → Pattern 1 (Simple Counting)
   • "...for each [dimension]" → Pattern 2 (Aggregation by Dimension)
   • "Which majors..." → Pattern 3 (Ranking Dimensions)
   • "Top N students..." → Pattern 4 (Top N)
   • "Breakdown by..." → Pattern 5 (Distribution)

3. Apply Default Assumptions - Filter for active students unless explicitly stated otherwise

4. Check Standard Metric Definitions for ambiguous terms like "financial support"