1SELECT
2  award_year,
3  COUNT(*) AS total_awards,
4  ROUND(SUM(award_amount), 1) AS total_awarded,
5  ROUND(AVG(award_amount), 0) AS avg_award_amount,
6  COUNT(
7    CASE
8      WHEN program = 'SBIR' THEN 1
9    END
10  ) AS sbir_count,
11  COUNT(
12    CASE
13      WHEN program = 'STTR' THEN 1
14    END
15  ) AS sttr_count
16FROM
17  "@sbir.awards.awards"
18WHERE
19  award_year BETWEEN 2000 AND 2025
20GROUP BY
21  award_year
22ORDER BY
23  award_year ASC