-- To get distinct value of a column select distinct [ship mode] from orders; Select distinct [order date] from orders order by [order date]; -- i want to select two column select distinct [order date ...

Now we need to group by product and month, sum up sales amount, and then convert products from rows to columns.