ed Help Seve & E Submit A company has the following three datasets in the database. Customer Customer customer_name city state 100525 Costco Issaquah MA 100558 Walmart Bentonville AR 100623 Target Minneapolis MN 100879 Trader Joe's Monrovia ICA 100950 Sam's Club Bentonville AR Transaction tranid date product_id customer_id revenue 2020/9 100526 1,000,000 2 2020/9/1 15 00623 50,000 2020/9/2 foo950 20.000 2020/9/5 17 00526 10,000 2020/95 15 100558 45,000 2020/9/16 119 10087% 84,000 2020/976 17 ho0526 7000 Product product.id product name 71 Product A 13 Product B 15 Product Product D 19 Product E Requirement 1: Your manager asked you to sum the total revenues by each product_id based on the information in the Transaction table. Please rename this sum variable as reveune_sum and sort the results by productid. If you are using Microsoft SQL Server Management Studio, what would be the SQL queries? This question will be sent to your instructor for grading 17 15 119 Product A 13 Products Product Product D Product E Requirement 1: Your manager asked you sum the total revenues by each product_id based on the information in the Transaction table. Please rename this sum variable as reveune_sum and sort the results by product_id. If you are using Microsoft SQL Server Management Studio, what would be the SQL queries? Requirement 2: The manager asked you to prepare a merged table for further reporting purposes. He wants the date and revenue information from the Transaction table, as well as the customer names, state, and the actual product names for the sample period of September 1 to September 15, 2020. If you are using Microsoft SQL Server Management Studio, what would be the SQL queries? Snort Answer Toot BIVS = = 2 P This question will be sent to your instructor for grading. ed Help Seve & E Submit A company has the following three datasets in the database. Customer Customer customer_name city state 100525 Costco Issaquah MA 100558 Walmart Bentonville AR 100623 Target Minneapolis MN 100879 Trader Joe's Monrovia ICA 100950 Sam's Club Bentonville AR Transaction tranid date product_id customer_id revenue 2020/9 100526 1,000,000 2 2020/9/1 15 00623 50,000 2020/9/2 foo950 20.000 2020/9/5 17 00526 10,000 2020/95 15 100558 45,000 2020/9/16 119 10087% 84,000 2020/976 17 ho0526 7000 Product product.id product name 71 Product A 13 Product B 15 Product Product D 19 Product E Requirement 1: Your manager asked you to sum the total revenues by each product_id based on the information in the Transaction table. Please rename this sum variable as reveune_sum and sort the results by productid. If you are using Microsoft SQL Server Management Studio, what would be the SQL queries? This question will be sent to your instructor for grading 17 15 119 Product A 13 Products Product Product D Product E Requirement 1: Your manager asked you sum the total revenues by each product_id based on the information in the Transaction table. Please rename this sum variable as reveune_sum and sort the results by product_id. If you are using Microsoft SQL Server Management Studio, what would be the SQL queries? Requirement 2: The manager asked you to prepare a merged table for further reporting purposes. He wants the date and revenue information from the Transaction table, as well as the customer names, state, and the actual product names for the sample period of September 1 to September 15, 2020. If you are using Microsoft SQL Server Management Studio, what would be the SQL queries? Snort Answer Toot BIVS = = 2 P This question will be sent to your instructor for grading.