add count as sql type; no order, limit, nor offset.