framework/resources/Functional/aggregates/aggregate/drill_4474_g.q

SELECT
    COUNT(case when state = 'FL' AND age > 24 AND age < 49 then id end)
FROM `drill_4474.parquet`;