Sequence

Query

SELECT

a1.Contract,

a1.Asset_Key,

Count(*) AS CategoryRank

FROM

Raw_Data AS a1

INNER JOIN

Analysis AS a2

ON (a1.Asset_Key <= a2.Asset_Key)

AND (a1.Contract = a2.Contract)

GROUP BY

a1.Contract,

a1.Asset_Key;

Results