KR FN in Yodlee

[mrubin-coatue]

SELECT
  is_purchase,
  tagged_agg.merchant_name,
  merchant_map.ticker as merchant_ticker,
  tagged_agg.ticker,
  description,
  canonical_description,
  count,
  total_amount,
  average_amount
FROM yodlee.tagged_aggregations tagged_agg
JOIN yodlee.merchant_name_ticker_mapping merchant_map
  ON tagged_agg.merchant_name = merchant_map.merchant_name
LEFT JOIN yodlee.ticker_subticker_map subticker_map -- inconsistent handling of subtickers in merchant map
  ON merchant_map.ticker = subticker_map.subticker
LEFT JOIN yodlee.ticker_subticker_map ticker_map
  ON merchant_map.ticker = subticker_map.ticker
WHERE 1 = 1
AND (tagged_agg.ticker IS NULL OR tagged_agg.ticker <> COALESCE(subticker_map.subticker, ticker_map.subticker))
AND merchant_map.ticker = 'KR'
ORDER BY total_amount DESC
LIMIT 500;