Discuss when to use the GROUP BY clause
What will be an ideal response?
The GROUP BY clause is useful when you have a set of values for one column (such as a salesperson ID) and you would like to then calculate something like total sales for each salesperson. Rather than having to use the sum function with one salesperson's ID in the WHERE clause (and run multiple queries) you can use the GROUP BY to get the same results in one query.
You might also like to view...
The first step in the social marketing planning process is ________
A) determining the focus of the program B) selecting the target audience C) setting objectives and goals D) designing the market offering E) finding a source of funding
Grisham is the financial manager of Plink Inc., an electronics company. He invests a major portion of the company's profit in his business. He believes that money has the potential to grow in value over a certain period, which is why he prefers to receive and invest an amount of money today rather than in the future. In this scenario, Grisham is most likely to be influenced by _____ while utilizing the finances of the company.
A. revolving credit agreement B. net present value C. retained earnings D. time value of money
In a multiple regression model, the variance of the error term ? is assumed to be
A. the same for all values of the dependent variable. B. zero. C. the same for all values of the independent variable. D. one.
Oakdale Co. borrowed $1,960,000 cash from Eugene National Bank last year. In addition, the company repaid a $1,260,000 note payable to Michigan State Bank. How should these transactions be listed in the Statement of Cash Flows?
A. A decrease to cash for $1,260,000 is listed in the investing activities section and an increase of $1,960,000 is in the financing activities section. B. Transactions must be shown separately as a decrease to cash for $1,260,000 and an increase of $1,960,000 in the financing activities section. C. Oakdale can combine the transactions and show an increase to cash of $700,000 in the financing activities section of the statement. D. Oakdale can combine the transactions and show an increase to cash of $700,000 in the investing activities section of the statement.