Answer:
See Explanation
Explanation:
Given
See attachment 1 for proper table definition
To answer this question, one of the basic sql commands (the "create" command) will be used to create the required table, followed by the fields of the table.
<em>I could not submit my answer directly. So, I added two additional attachments which represent the answer section and the explanation section, respectively.</em>
Ctrl + v pastes copied text, ctrl + p brings up a print menu, ctrl + x cuts and copies highlighted text, while ctrl + c copies the highlighted text.
Answer:
=POWER(2,14)
Explanation:
The complete question is to write the given formula in cell F1
We have:

The above formula implies 2 raised to the power of 14.
In Excel, this can be achieved using the power function
And the syntax is:
=POWER(m,n)
which means m^n
So, 2^14 will be entered in cell F1 as:
=POWER(2,14)
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;