SQL COUNT() and ROW_NUMBER() Function with PARTITION BY for 1 of n Items

SQL COUNT() and ROW_NUMBER() Function with PARTITION BY for 1 of n Items

More to explore

Based on this image's title: “SQL COUNT() and ROW_NUMBER() Function with PARTITION BY for 1 of n Items”