the question is : the SQL command to list the number of product sales (number of rows) and total sales by month, with subtotals by month and a grand total for all sales? i try to use SELECT TM_ MONTH , COUNT (*) AS NUMPROD , SUM ( SALE_UNITS * SALE_PRICE ) AS TOTSALES FROM DWDAYSALESFACT S JOIN DWTIME T ON S.TM_ID = T.TM_ID but ites incorrect ORA-00907: ¿¿¿¿¿ 00907. 00000 - "missing right parenthesis" *Cause: *Action: can the one answer me try the code it self and sure ites workable ?
the question is : the SQL command to list the number of product sales (number of rows) and total sales by month, with subtotals by month and a grand total for all sales?
i try to use
SELECT TM_ MONTH , COUNT (*) AS NUMPROD , SUM ( SALE_UNITS * SALE_PRICE ) AS TOTSALES
FROM DWDAYSALESFACT S JOIN DWTIME T ON S.TM_ID = T.TM_ID
but ites incorrect
ORA-00907: ¿¿¿¿¿
00907. 00000 - "missing right parenthesis"
*Cause:
*Action:
can the one answer me try the code it self and sure ites workable ?
CREATE TABLE DWVENDOR (
V_CODE INTEGER PRIMARY KEY,
V_NAME VARCHAR(35),
V_AREACODE CHAR(3),
V_STATE CHAR(2));
CREATE TABLE DWPRODUCT (
P_CODE VARCHAR2(10) PRIMARY KEY,
P_DESCRIPT VARCHAR2(35),
P_CATEGORY VARCHAR(5),
V_CODE NUMBER REFERENCES DWVENDOR);
CREATE TABLE DWREGION (
REG_ID INTEGER PRIMARY KEY,
REG_NAME VARCHAR(10));
CREATE TABLE DWCUSTOMER (
CUS_CODE NUMBER PRIMARY KEY,
CUS_LNAME VARCHAR(15),
CUS_FNAME VARCHAR(15),
CUS_INITIAL CHAR(1),
CUS_STATE CHAR(2),
REG_ID NUMBER REFERENCES DWREGION);
CREATE TABLE DWTIME (
TM_ID INTEGER PRIMARY KEY,
TM_YEAR INTEGER,
TM_MONTH INTEGER,
TM_DAY INTEGER,
TM_QTR INTEGER);
CREATE TABLE DWDAYSALESFACT (
TM_ID NUMBER,
CUS_CODE NUMBER,
P_CODE VARCHAR(10),
SALE_UNITS NUMBER,
SALE_PRICE NUMBER,
PRIMARY KEY (TM_ID, CUS_CODE, P_CODE));
all the answers i get is uesless .
GROUP BY ROLLUP (T.TM_ MONTH) ORDER BY T.TM_ MONTH
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
