SQL query questions please no special functions. Table: create table sales cust varchar(20), prod varchar(20), day integer, month integer, year integer, state char(2), quant integer, date date...


SQL query questions please no special functions.<br>Table:<br>create table sales<br>cust varchar(20),<br>prod varchar(20),<br>day integer,<br>month integer,<br>year integer,<br>state char(2),<br>quant integer,<br>date date<br>Question:<br>For customer and product, show the average sales before, during and after each month (e.g., for<br>February, show average sales of January and March. For
284 434 Sam Eggs 254 539 325 "/>
Extracted text: SQL query questions please no special functions. Table: create table sales cust varchar(20), prod varchar(20), day integer, month integer, year integer, state char(2), quant integer, date date Question: For customer and product, show the average sales before, during and after each month (e.g., for February, show average sales of January and March. For "before" January and "after" December, display NULL. The "YEAR" attribute is not considered for this query - for example, both January of 2017 and January of 2018 are considered January regardless of the year. Report: DURING AVG CUSTOMER PRODUCT ΜOΝΤΗ BEFORE_AVG AFTER_AVG Boo Fish 1 284 434 Sam Eggs 254 539 325

Jun 05, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here