MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `products` (
  `product_name` varchar(250) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `sales` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `products` */
insert  into `products`(`product_name`,`date`,`sales`) values 
('Micro','2020-08-01',100),
('Micro','2020-08-02',200),
('x','2020-08-02',300),
('y','2020-08-01',300),
('z','2020-08-03',400),
('x','2020-08-03',400),
('y','2020-08-10',500),
('z','2020-08-10',500),
('x','2020-08-10',500),
('y','2020-08-10',500),
('z','2020-08-10',500),
('x','2020-08-10',500),
('y','2020-08-10',500),
('z','2020-08-10',500),
('x','2020-08-11',230),
('y','2020-08-11',210),
('z','2020-08-11',240);

Records: 17  Duplicates: 0  Warnings: 0


SET @sql = NULL;
SELECT
  GROUP_CONCAT(DISTINCT
    CONCAT(
      'max(CASE WHEN date = ''',
      DATE_FORMAT(DATE, '%Y-%m-%d'),
      ''' THEN round(sales,2) end) AS `',
      
      DATE_FORMAT(DATE, '%Y-%m-%d'), '`'
    )
  ) INTO @sql
  
  FROM `temp_sale` WHERE DATE BETWEEN DATE_ADD("2020-08-12",INTERVAL -29 DAY) AND "2020-08-12" ;


Table 'fiddle.temp_sale' doesn't exist


SELECT 
  GROUP_CONCAT(DISTINCT
    CONCAT(
      'SUM(CASE WEEK(`date`) WHEN "',
     WEEK(`date`),
      '" THEN `sales` ELSE 0 END) AS `',
      CONCAT('week-',WEEK(`date`)), '`'      
    )
    ORDER BY WEEK(`date`)
  ) 
  INTO @sql
FROM products as p
SET @sql = CONCAT('select product_name,SUM(`sales`), ',@sql,' from products
group by product_name');

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

Statement prepared




product_name
SUM(`sales`)
week-30
week-31
week-32


Micro
300
100
200
0

x
1930
0
700
1230

y
2010
300
0
1710

z
2140
0
400
1740