Revenue Assumptions

An extra table with average revenue for student groups.

CREATE OR REPLACE TABLE marketing_revenue_assumptions AS

SELECT 2025 AS fiscal_year, 'undergraduate_resident' AS student_group, 10131.00 AS avg_net_tuition_revenue
UNION ALL
SELECT 2025, 'undergraduate_nonresident', 22284.00
UNION ALL
SELECT 2025, 'graduate', 25582.00
UNION ALL
SELECT 2025, 'regionals', 6161.00;