SELECT
  `GO_TIME_DIM`.`CURRENT_YEAR`,
  `Product__brand_`.`PRODUCT_BRAND_KEY`,
  `SLS_SALES_FACT`.`SALE_TOTAL`
FROM
  `gosalesdw_1021`.`emp_employee_dim` `EMP_EMPLOYEE_DIM`
  INNER JOIN `gosalesdw_1021`.`go_branch_dim` `GO_BRANCH_DIM` ON `EMP_EMPLOYEE_DIM`.`BRANCH_CODE` = `GO_BRANCH_DIM`.`BRANCH_CODE`
  INNER JOIN `gosalesdw_1021`.`sls_sales_fact` `SLS_SALES_FACT` ON `SLS_SALES_FACT`.`EMPLOYEE_KEY` = `EMP_EMPLOYEE_DIM`.`EMPLOYEE_KEY`
  INNER JOIN `gosalesdw_1021`.`go_time_dim` `GO_TIME_DIM` ON `SLS_SALES_FACT`.`ORDER_DAY_KEY` = `GO_TIME_DIM`.`DAY_KEY`
  INNER JOIN (
    SELECT
      `SLS_PRODUCT_DIM`.`PRODUCT_BRAND_KEY` AS `PRODUCT_BRAND_KEY`,
      `SLS_PRODUCT_DIM`.`PRODUCT_KEY` AS `PRODUCT_KEY`
    FROM
      `gosalesdw_1021`.`sls_product_brand_lookup` `SLS_PRODUCT_BRAND_LOOKUP`
      INNER JOIN `gosalesdw_1021`.`sls_product_dim` `SLS_PRODUCT_DIM` ON `SLS_PRODUCT_BRAND_LOOKUP`.`PRODUCT_BRAND_CODE` = `SLS_PRODUCT_DIM`.`PRODUCT_BRAND_CODE`
      INNER JOIN `gosalesdw_1021`.`sls_product_color_lookup` `SLS_PRODUCT_COLOR_LOOKUP` ON `SLS_PRODUCT_DIM`.`PRODUCT_COLOR_CODE` = `SLS_PRODUCT_COLOR_LOOKUP`.`PRODUCT_COLOR_CODE`
      INNER JOIN `gosalesdw_1021`.`sls_product_line_lookup` `SLS_PRODUCT_LINE_LOOKUP` ON `SLS_PRODUCT_DIM`.`PRODUCT_LINE_CODE` = `SLS_PRODUCT_LINE_LOOKUP`.`PRODUCT_LINE_CODE`
      INNER JOIN (
        SELECT
          `SLS_PRODUCT_LOOKUP`.`PRODUCT_NUMBER` AS `PRODUCT_NUMBER`
        FROM
          `gosalesdw_1021`.`sls_product_lookup` `SLS_PRODUCT_LOOKUP`
        WHERE
          `SLS_PRODUCT_LOOKUP`.`PRODUCT_LANGUAGE` = 'EN'
      ) `SLS_PRODUCT_LOOKUP0` ON `SLS_PRODUCT_DIM`.`PRODUCT_NUMBER` = `SLS_PRODUCT_LOOKUP0`.`PRODUCT_NUMBER`
      INNER JOIN `gosalesdw_1021`.`sls_product_size_lookup` `SLS_PRODUCT_SIZE_LOOKUP` ON `SLS_PRODUCT_DIM`.`PRODUCT_SIZE_CODE` = `SLS_PRODUCT_SIZE_LOOKUP`.`PRODUCT_SIZE_CODE`
      INNER JOIN `gosalesdw_1021`.`sls_product_type_lookup` `SLS_PRODUCT_TYPE_LOOKUP` ON `SLS_PRODUCT_DIM`.`PRODUCT_TYPE_CODE` = `SLS_PRODUCT_TYPE_LOOKUP`.`PRODUCT_TYPE_CODE`
  ) `Product__brand_` ON `Product__brand_`.`PRODUCT_KEY` = `SLS_SALES_FACT`.`PRODUCT_KEY`
  INNER JOIN (
    SELECT
      `SLS_PRODUCT_DIM`.`PRODUCT_TYPE_KEY` AS `Product_type_key`,
      `SLS_PRODUCT_DIM`.`PRODUCT_KEY` AS `Product_key`
    FROM
      `gosalesdw_1021`.`sls_product_brand_lookup` `SLS_PRODUCT_BRAND_LOOKUP`
      INNER JOIN `gosalesdw_1021`.`sls_product_dim` `SLS_PRODUCT_DIM` ON `SLS_PRODUCT_BRAND_LOOKUP`.`PRODUCT_BRAND_CODE` = `SLS_PRODUCT_DIM`.`PRODUCT_BRAND_CODE`
      INNER JOIN `gosalesdw_1021`.`sls_product_color_lookup` `SLS_PRODUCT_COLOR_LOOKUP` ON `SLS_PRODUCT_DIM`.`PRODUCT_COLOR_CODE` = `SLS_PRODUCT_COLOR_LOOKUP`.`PRODUCT_COLOR_CODE`
      INNER JOIN `gosalesdw_1021`.`sls_product_line_lookup` `SLS_PRODUCT_LINE_LOOKUP` ON `SLS_PRODUCT_DIM`.`PRODUCT_LINE_CODE` = `SLS_PRODUCT_LINE_LOOKUP`.`PRODUCT_LINE_CODE`
      INNER JOIN (
        SELECT
          `SLS_PRODUCT_LOOKUP`.`PRODUCT_NUMBER` AS `PRODUCT_NUMBER`
        FROM
          `gosalesdw_1021`.`sls_product_lookup` `SLS_PRODUCT_LOOKUP`
        WHERE
          `SLS_PRODUCT_LOOKUP`.`PRODUCT_LANGUAGE` = 'EN'
      ) `SLS_PRODUCT_LOOKUP0` ON `SLS_PRODUCT_DIM`.`PRODUCT_NUMBER` = `SLS_PRODUCT_LOOKUP0`.`PRODUCT_NUMBER`
      INNER JOIN `gosalesdw_1021`.`sls_product_size_lookup` `SLS_PRODUCT_SIZE_LOOKUP` ON `SLS_PRODUCT_DIM`.`PRODUCT_SIZE_CODE` = `SLS_PRODUCT_SIZE_LOOKUP`.`PRODUCT_SIZE_CODE`
      INNER JOIN `gosalesdw_1021`.`sls_product_type_lookup` `SLS_PRODUCT_TYPE_LOOKUP` ON `SLS_PRODUCT_DIM`.`PRODUCT_TYPE_CODE` = `SLS_PRODUCT_TYPE_LOOKUP`.`PRODUCT_TYPE_CODE`
  ) `Product` ON `Product`.`Product_key` = `SLS_SALES_FACT`.`PRODUCT_KEY`
  INNER JOIN (
    SELECT
      `Retailer_region_dimension`.`REGION_CODE` AS `Region_code`,
      `SLS_RETAILER_DIM`.`RETAILER_KEY` AS `Retailer_key`,
      `SLS_RETAILER_DIM`.`RETAILER_SITE_KEY` AS `Retailer_site_key`
    FROM
      (
        SELECT
          `GO_REGION_DIM`.`REGION_CODE` AS `REGION_CODE`,
          `GO_REGION_DIM`.`COUNTRY_KEY` AS `COUNTRY_KEY`,
          `GO_REGION_DIM`.`COUNTRY_CODE` AS `COUNTRY_CODE`,
          `GO_REGION_DIM`.`ISO_THREE_LETTER_CODE` AS `ISO_THREE_LETTER_CODE`,
          `GO_REGION_DIM`.`ISO_TWO_LETTER_CODE` AS `ISO_TWO_LETTER_CODE`,
          `GO_REGION_DIM`.`ISO_THREE_DIGIT_CODE` AS `ISO_THREE_DIGIT_CODE`,
          `GO_REGION_DIM`.`REGION_KEY` AS `REGION_KEY`,
          `GO_REGION_DIM`.`REGION_EN` AS `Region`,
          `GO_REGION_DIM`.`COUNTRY_EN` AS `Country`,
          concat(
            '../samples/images/',
            `GO_REGION_DIM`.`FLAG_IMAGE`
          ) AS `FLAG_IMAGE`
        FROM
          `gosalesdw_1021`.`go_region_dim` `GO_REGION_DIM`
      ) `Retailer_region_dimension`
      INNER JOIN `gosalesdw_1021`.`sls_rtl_dim` `SLS_RETAILER_DIM` ON `Retailer_region_dimension`.`COUNTRY_CODE` = `SLS_RETAILER_DIM`.`RTL_COUNTRY_CODE`
  ) `Retailer_site` ON `Retailer_site`.`Retailer_site_key` = `SLS_SALES_FACT`.`RETAILER_SITE_KEY`
  INNER JOIN (
    SELECT
      `SLS_RETAILER_DIM`.`RETAILER_TYPE_CODE` AS `Retailer_type_code`,
      `SLS_RETAILER_DIM`.`RETAILER_KEY` AS `Retailer_key`
    FROM
      `gosalesdw_1021`.`sls_rtl_dim` `SLS_RETAILER_DIM`
    GROUP BY
      `SLS_RETAILER_DIM`.`RETAILER_TYPE_CODE`,
      `SLS_RETAILER_DIM`.`RETAILER_KEY`
  ) `Retailer` ON `Retailer`.`Retailer_key` = `Retailer_site`.`Retailer_key`
WHERE
  `GO_BRANCH_DIM`.`BRANCH_KEY` IN (9929)
  AND `Product`.`Product_type_key` IN (961)
  AND `Retailer_site`.`Region_code` = 740
  AND `Retailer`.`Retailer_type_code` = 7