Everything is queryable.

-- Find high-spend states for Heart Failure
-- where clinical intensity is below the national average
SELECT
  state_abbr,
  total_beneficiaries,
  total_allowed_amt    AS Market_Magnitude,
  allowed_per_patient  AS Economic_Density,
  services_per_patient AS Utilization_Velocity
FROM mat_condition_state_breakdown
WHERE condition_name = 'Heart Failure'
  AND services_per_patient < (
    SELECT AVG(services_per_patient)
    FROM mat_condition_national_summary
    WHERE condition_name = 'Heart Failure'
  )
ORDER BY total_allowed_amt DESC
LIMIT 10;