WGU D427 Chapter 2 Answered 100%

IN - ANSWER-This operator is used in a WHERE clause to determine if a value matches one of several values. BETWEEN - ANSWER-This operator provides an alternative way to determine if a value is between two other values. The operator is written value ________ minValue AND maxValue and is equivalent to value = minValue AND value = maxValue. LIKE - ANSWER-This operator, when used in a WHERE clause, matches text against a pattern using the two wildcard characters % and _. BINARY - ANSWER-This operator performs case-insensitive pattern matching by default or case-sensitive pattern matching if followed by the __________ keyword. DISTINCT - ANSWER-This clause is used with a SELECT statement to return only unique or _________ values. ORDER BY - ANSWER-This clause orders selected rows by one or more columns in ascending (alphabetic or increasing) order. DESC - ANSWER-This keyword with the ORDER BY clause orders rows in descending order. function / argument - ANSWER-A function operates on an expression enclosed in parentheses, called an argument, and returns a value. Usually, the argument is a simple expression, such as a column name or fixed value. Some functions have several arguments, separated by commas, and a few have no arguments at all. aggregate function - ANSWER-processes values from a set of rows and returns a summary value. COUNT() - ANSWER-counts the number of rows in the set. MIN() - ANSWER-finds the minimum value in the set. MAX() - ANSWER-finds the maximum value in the set. SUM() - ANSWER-sums all the values in the set. AVG() - ANSWER-computes the arithmetic mean of all the values in the set. GROUP BY - ANSWER-This clause consists of the __________ _______keyword and one or more columns. Each simple or composite value of the column(s) becomes a group. The query computes the aggregate function separately, and returns one row, for each group.