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.
The correct answer has not yet been found for the question. Our moderators are looking for the most suitable solutions for you. Could you share your comments with us for the answer to this question?