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:
<u>query,</u> <u>data mining </u>
Explanation:
A query can be explained as another term for question.
If one needs additional information from some other person, he might have ask to him. Queries are used for the retrieval of the information.
In other words, one tries to find what have been prepared by others.
Data mining can be explained as the process that allows to sort through a large set of data for the identification of patterns.
In this process of data mining, one tries to find out the new patterns that may not be known at all.
Since Betty is applying for a software analyst role, she should specialize in INFORMATION TECHNOLOGY.
<span>Information technology or IT is defined as the study or use of systems in computers and telecommunications for storing, retrieving, and sending information.
</span>
Betty's role as a software analyst would be to:
1) <span> study the </span>software<span> application domain,
2) prepare </span>software<span> requirements and specification (</span>Software<span> Requirements Specification) documents.
3) be the link between the software users and software developers.</span>
what are you asking? cause this is a werid question
Scarcity of availability causes producers to either charge
higher prices or to produce more goods and services (like energy
production, cars, paper, etc.)