Using the tPurchaseltem table, write a query that retrieves the total purchase amount for each comination of PurchaseType and PurchaseDate, subtotals for each PurchaseType, and the grand total. Hint: You will need use the Sum function with PurchaseAmt to calculate the total purchase amount for each grouping set. You will need 3 different groupings.

Question

Using the tPurchaseltem table, write a query that retrieves the total purchase amount for each comination of PurchaseType and PurchaseDate, subtotals for each PurchaseType, and the grand total. Hint: You will need use the Sum function with PurchaseAmt to calculate the total purchase amount for each grouping set. You will need 3 different groupings. (PurchaseType, PurchaseDate): This grouping will provide the total purchase amount for each unique combination of PurchaseType and PurchaseDate. (PurchaseType): This grouping will provide subtotals for each unique PurchaseType. 0: This grouping will provide the grand total of all purchases without any specific grouping.  columns in the purchase item table are purchaseID supplier, purchasetype, purchaseamount and purchasedate

Accepted Answer

Expert Answer to - Using the tPurchaseltem table, write a query that retrieves the total purchase amount for each comin

Answer

Solution for - Using the tPurchaseltem table, write a query that retrieves the total purchase amount for each comin

Answer

This an additional answer to - Using the tPurchaseltem table, write a query that retrieves the total purchase amount for each comin

(Solved): Using the tPurchaseltem table, write a query that retrieves the total purchase amount for each comin ...

View Expert Answer

Expert Answer

Buy This Answer $5

Place Order

We Provide Services Across The Globe