Question 1 (3 points) The following are all valid locations in an SQL query for a subquery. According to the text, which is the most commonly used? In the ORDER BY clause as a sort order In the SELECT clause as a scalar value In the FROM clause as a virtual table In the WHERE or HAVING clause as a subquery search condition Question 2 (3 points) A subquery comparison as a condition in the WHERE clause can sometimes be used as an alternative to joining tables (i.e. both methods can sometimes be viable solutions). Which of the following is an advantage of using a subquery solution? The query will typically perform faster You can include columns from both tables in the output Subquery solutions can be easier to code for short, simple queries You can use a subquery to pass an aggregate calculation to the outer query Question 3 (3 points) The IN comparison can be used in SQL Server to compare a value against a list of hard- coded values; it can also be used to compare against a dynamically-generated list by using a subquery. Which of the following is true for this type of comparison? The subquery must include a correlation The subquery must return a single value The subquery must return a single column of values The subquery must return a single row of values Question 4 (3 points) when using a comparison operator (e.g.) 3(# etc.) against a subquery, the subquery must return a single value (one row, one column); otherwise an error will result. What is one method to make this type of comparison and avoid the error? Write the subquery using an aggregate calculation Include multiple columns in your SELECT clause Code the condition with one of the keywords ANY, SOME, or ALL Convert numeric values to strings Question 5 (3 points) WHERE clause comparisons against a subquery can use comparison operators (e.g. +>