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?
