I have a simple query like this (identify hosts that have more than one request):
select host, count(1) as cnt from accesslogs where cnt>1 group by host; and it throws the error Invalid Table Alias or Column Reference cnt. Is using column alias like this unsupported? Is there another way of achieving the same query as above?
