You correctly identified the issue. In BigQuery (and standard SQL), if you want to select a column alongside an aggregate like COUNT(*), you need to include that column in a GROUP BY clause. For example:

SELECT usertype, COUNT(*)
FROM `project.dataset.table`
GROUP BY usertype;