HOW TO REPORT YEAR WISE, QUARTER WISE TOTAL SALES AND TOTAL TAX?

engineering

Description


- Q1: HOW TO REPORT YEAR WISE TOTAL SALES?

-- Q2:  HOW TO REPORT YEAR WISE, QUARTER WISE TOTAL SALES AND TOTAL TAX?

-- Q3:  HOW TO REPORT YEAR WISE, QUARTER WISE, MONTH WISE TOTAL SALES AND TOTAL TAX?

-- Q4:  HOW TO REPORT YEAR WISE, QUARTER WISE TOTAL SALES AND TOTAL TAX FOR JUNE MONTH ?

-- Q5:  HOW TO REPORT CLASS WISE, COLOR WISE PRODUCTS FOR EACH YEAR BASED ON ASC ORDER OF SALES?

-- Q6: HOW TO REPORT AVERAGED SALES AND AVERAGED TAX FOR SUCH PRODUCTS WITH MAXIMUM LIST PRICE AND HIGHEST STANDARD PRICE?

-- Q7: HOW TO REPORT AVERAGED SALES AND AVERAGED TAX FOR SUCH HIGH CLASS RED COLORED PRODUCTS WITH MAXIMUM LIST PRICE FROM?

-- Q8: HOW TO COMBINE THE RESULTS FROM ABOVE TWO QUERIES. HOW TO MAKE IT FASTER?

-- Q9: HOW TO REPORT AVERAGE SALES AND AVERAGE TAX FOR ALL FEMALE CUSTOMERS FROM 2001 TO 2003 YEAR?

-- Q10: HOW TO REPORT YEAR WISE, CUSTOMER WISE, PRODUCT WISE TOTAL SALES AND TOTAL TAX ABOVE 1000 USD?


Instruction Files

Related Questions in engineering category