SELECT column_name, data_type
FROM information_schema.columns
WHERE table_name = 'sjreport'
ORDER BY ordinal_position

select distinct 
category,brand,product,variant,size
from sjreport
group by category,brand,product,variant,size


select distinct 
brand
from sjreport
group by brand


select * from product 

CREATE TABLE temp_products (
	channel text,
    category text,
    brand text,
    product text,
    variant text,
    size text
);

SELECT channel,category, brand, product, variant, size
FROM temp_products

drop table temp_products 


select count(*) from sjreport where week_start_date = '2024-09-09'

select count(*) from task where week_start_date = '2024-09-09'