Do the following in MySQL if possible, and copy-and-paste the commands into Blackboard or put screen shots into a Word document and attach that to Blackboard. . If you do not have access to MySQL you may type the commands directly into Blackboard, but your chances of making a mistake without testing in MySQL are high Using the Zagi database, write queries that will accomplish the following: 1. Using the salestransaction table, display the Customer ID and total number of transactions for each customer 2. Display the transaction date and total number of transactions on each date. 3. Display the store id and number of transactions per store 4. Using the soldvia table, display the transaction id and total number of items sold on each transaction. 5. Display the product id and total number of items sold for each product. Hint: each of these uses the GROUP BY function. Do the following in MySQL if possible, and copy-and-paste the commands into Blackboard or put screen shots into a Word document and attach that to Blackboard. . If you do not have access to MySQL you may type the commands directly into Blackboard, but your chances of making a mistake without testing in MySQL are high Using the Zagi database, write queries that will accomplish the following: 1. Using the salestransaction table, display the Customer ID and total number of transactions for each customer 2. Display the transaction date and total number of transactions on each date. 3. Display the store id and number of transactions per store 4. Using the soldvia table, display the transaction id and total number of items sold on each transaction. 5. Display the product id and total number of items sold for each product. Hint: each of these uses the GROUP BY function