A Texas district's STAAR %Meets over time (search by district)

Custom SQL query returning more than 2,000 rows (hide)

SELECT mu.name AS district, s.year, s.grade, s.subject, s.meets_pct
FROM staar_results s JOIN municipalities mu ON mu.id = s.muni_id
WHERE lower(mu.name) LIKE '%' || lower(:district) || '%'
ORDER BY s.subject, s.grade, s.year

Query parameters

district

Edit SQL