Tcmg 316 Quiz 6 Study Study Guide Rated A+

Expressions coded in the WHERE clause a. must refer to columns in the SELECT clause b. can use non-aggregate search conditions but can't use aggregate search conditions c. can use aggregate search conditions but can't use non-aggregate search conditions d. can use either aggregate search conditions or non-aggregate search conditions {Ans: b. can use non-aggregate search conditions but can't use aggregate search conditions}Which of the following best describes when you should consider using a named window? a. Any time a SELECT statement includes two or more aggregate window functions that use the same partitions. b. Any time a SELECT statement includes two or more aggregate window functions. c. Any time you want to be able to add to the definitions of two or more aggregate window functions. d. Any time a SELECT statement includes two or more aggregate window functions that use partitions. {Ans: a. Any time a SELECT statement includes two or more aggregate window functions that use the same partitions.}Which of the statements below best describes the result set returned by this SELECT statement? SELECT COUNT(DISTINCT invoice_id) AS 'count', ROUND(AVG(line_item_amount), 2) AS average_amount FROM invoice_line_items a. A single row with a count of the invoices in