TDCustmerSupportJP

Untitled

Aug 1st, 2017
57
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT country_name, raw.code AS brand_code, master_brand.name AS brand_name, COUNT(1) AS cnt
  2. FROM usedcar raw
  3. JOIN
  4. ( SELECT code, name, country_name FROM brand_master ) master_brand
  5. ON
  6. raw.code = master_brand.code
  7. WHERE country_name = '日本'
  8. GROUP BY country_name, raw.code, master_brand.name
  9. ORDER BY brand_name
RAW Paste Data