SELECT Retail_Store.str_nm AS str_nm, Tetail_Str_Sales_Detail.sale_date AS sale_date,
       MONTHNAME(Retail_Str_Sales_Detail.sale_date) AS monthname, WEEK(Retail_Str_Sales_Detail.sale_date) AS week, DAY(Retail_Str_Sales_Detail.sale_date) AS day_of_week,
       Retail_Str_Sales_Detail.prod_id, Retail_Str_Sales_Detail.prod_nm AS prod_nm,
       Retail_Str_Sales_Detail.qty AS qty, ROUND(Retail_Str_Sales_Detail.total, 2) AS total, Retail_Str_Sales_Detail.uom AS uom,
       Retail_Store_Product_Hemas.hemas_id AS hemas_id, Retail_Store_Product_hemas.mfg_id, Retail_Str_Sales_Detail.tri_id
FROM Retail_Store_Product_Hemas
JOIN Retail_Str_Sales_Detail
  ON Retail_Str_Sales_Detail.prod_id = Retail_Store_Product_Hemas.prod_id
JOIN Retail_Dstr_Prod
  ON Retail_Dstr_Prod.prod_id = Retail_Str_Sales_Detail.prod_id
     AND Retail_Dstr_Prod.dstr_id = '1495220190'
JOIN Retail_Store
  ON Retail_Store.store_id = Retail_Str_Sales_Detail.store_id
ORDER BY Retail_Store.store_id ASC, Retail_Str_Sales_Detail.prod_nm ASC, Retail_Store.str_nm, Retail_Str_Sales_Detail.sale_date ASC