MySQL query generation help

[gotissues68]

Hi All!

I'm trying to build a query which something similar to the following

select count(LATA) from ohsnap where 45 Day ATS >=5 group by LATA order by LATA ASC;

Which returns the count result I'm looking for but I'd like to be able to display the associated LATA => Count. Is there any way to do this?

Thanks,
Drew-

[liquorvicar]

Will this not work for you?

select LATA,count(LATA) from ohsnap where `45 Day ATS` >=5 group by LATA order by LATA ASC;

[gotissues68]

Thanks liquorvicar! Thats exactly what I needed. I didn't know what syntax to use 🙁