Open mrubin-coatue opened 6 years ago
Using MCC codes: select industry, a.mcc, sum(count) from yodlee.tagged_aggregations a join arminsight.mcc_industry_mapping b on a.mcc = b.mcc where ticker = 'M' group by 1,2 order by 3 desc;
select industry, a.mcc, sum(count) from yodlee.tagged_aggregations a join arminsight.mcc_industry_mapping b on a.mcc = b.mcc where ticker = 'M' group by 1,2 order by 3 desc;
MACYS EUROPEAN COFFEE HOUFLAGSTAFF AZ
Using MCC codes:
select industry, a.mcc, sum(count) from yodlee.tagged_aggregations a join arminsight.mcc_industry_mapping b on a.mcc = b.mcc where ticker = 'M' group by 1,2 order by 3 desc;MACYS EUROPEAN COFFEE HOUFLAGSTAFF AZ