I'm sure this is easy, but I can't figure it. I keep getting an error on this saying that 'Initial' is an unknown column in the where clause.
SELECT system, acronym, id, year, cat, acronym, LEFT('system', 1) AS initial
FROM csap
WHERE year = '2004' AND initial = 'a'
ORDER...