$1.(2$ Marks$)$ Create a cross$-$tab query that displays the total quantity of each product sold byeach store. Here is a sample output.Note: We havent covered how to write SQL code for a cross$-$tab yet, so the visual QueryBuilder will help here.BlackteaChai cornflakescream$10\%$cream$18\%$ketchup maplesyrupmilk $1$litrepepper rolledoatssaltCalgary $111111$Number $12510141010511110$Selkirk No$.1($One$)11111$Woodcroft $10551183202050732.(2$ Marks$)$ Create a query that creates a new table called Prairies. This new table will containall of the records from the Province table for the following provinces: Albert, Saskatchewan,and Manitoba$\mathrm{.}3.(2$ Marks$)$ Create a query that returns the full name of the Province that has made the mostmoney $($has the highest total amountSold$)\mathrm{.}4.(2$ Marks$)$ Create a query that returns the names and cities of each store that has nevermade a sale$\mathrm{.}5.(2$ Marks$)$ Create a query that returns the following information in a single column:a$.$ The names of all products that cost $$4$ or lessb. The names of all categories that have a description containing a comma.Note: To solve this, you will need to use SQL to perform a UNION.