-- When count is used groupBy is needed select count(http_user_agent), http_user_agent from taxijakt.wave_drivers where last_checkin >= '2018-01-01' and http_user_agent like '%Android%' or http_user_agent like '%iPhone%' group by http_user_agent;