Query Revenue by Store: In this SQL query, you should create a view that calculates the revenue for each store between January 1, 2022, and March 31, 2022. The view should be named "reve and should include the store id column and a calculated column called "revenue" that represents the sum of sale price multiplied by quantity sold. The results should b sorted by store id. Code: CREATE VIEW revenue as SELECT a. type your answer.. sum (b. type your answer.. b type your answer.. as revenue FROM type your answer.. as LEFT JOIN type your answer.. as b ON a. type your answer. b. type your answer.. WHERE a. type your answer.. BETWEEN type your answer. AND type your answer.. GROUP BY a. type your answer... ORDER BY a. "store#"