Write SQL query to answer following requirements: 1. Output weekly sales per store for April 2012. In addition output on the same record store record, prior week sales, and prior year sales for the week (52 weeks back) 2. List of columns to output: 1. store 2. sales date 3. weekly-sales 4. prior week sales, and prior year sales for the week (52 weeks back) 3. Output information for April of 2012 only 4. Sort by store and sales date 5. Submit SQL and first 12 records.