A school district's board decisions next to its proficiency (search by district)

Custom SQL query returning 86 rows (hide)

SELECT mu.name AS district, mu.state, ss.read_pct_proficient, ss.math_pct_proficient,
       ss.per_pupil_spending, d.headline AS board_decision, m.meeting_date
FROM municipalities mu
LEFT JOIN school_stats ss ON ss.muni_id = mu.id
LEFT JOIN meetings m ON m.muni_id = mu.id
LEFT JOIN decisions d ON d.meeting_id = m.id
WHERE mu.kind='school' AND lower(mu.name) LIKE '%' || lower(:district) || '%'
ORDER BY m.meeting_date DESC LIMIT 200

Query parameters

district

Edit SQL