#1 is A and #2 is B, but I don't know about #3 and #4.
Answer:
The answer is below
Explanation:
The the sql command to list the total sales by customer , month , and product, with subtotals by customer and by month and a grand total for all product sales is:
SELECT S.CUS_CODE, T.TM_MONTH, S.P_CODE,
SUM(S.SALE_UNITS*S.SALE_PRICE) AS "TOTSALES"
FROM DWDAYSALESFACT AS S INNER JOIN DWTIME AS T ON S.TM_ID =
T.TM_ID
GROUP BY S.CUS_CODE,T.TM_MONTH,S.P_CODE WITH ROLLUP;
Answer:
350 kHz
Explanation:
as there are 100,000 character per sec.
so, total number of bits per sec = 100,000 * n
= 100,000 * 7 = 700,000 bits per sec
= 700 kbps
Bandwidth (BW) = total no. of bits / 2
BW = 700 kbps/2
= 350 kHz
