SELECT SUM(CASE WHEN name LIKE 'nick-1%'  THEN 1 ELSE 0 END) AS nick_count,
       SUM(CASE WHEN name LIKE 'vicky-1%' THEN 1 ELSE 0 END) AS vicky_count,
       SUM(CASE WHEN name NOT LIKE 'nick-1%' AND name NOT LIKE 'vicky-1%'
                THEN 1 ELSE 0 END) AS neither_count
FROM dummytable