blob: a2aa285c46e13ab45871b983c710c150cef548c1 [file] [log] [blame]
SELECT
employee_id,
position_id,
sub,
COUNT(*) OVER(PARTITION BY position_id, sub) AS `count`
FROM
%s