PT2520 Clarence Gross 2/9/12 Homework A scalar function operates on one row at a time. True And aggregate function works on multiple rows a time. True Whenever you have an aggregate function in a query criteria, you must use the HAVING keyword. False Any column in a SELECT that contains an aggregate function, but that is not a part of aggregate function, must be addressed in a GROUP BY clause. True An INNER JOIN returns all the records in the joined tables. False There is no error of the following SQL statement: SELECT CustomerCity, Count (CustomerKey) FROM Customer False There is no error of the following SQL statement: SELECT CustomerCity, Count (CustomerKey) FROM Customer GROUP BY CustomerCity WHERE Count(CustomerCity) > 20 True