4. When do you use the CASE WHEN function?  A. To perform conditional logic to return different values in a query result.B. To join multiple tables in a query.C. To group rows that have the same values in specified columns into summary rows.D. To sort the result set of a query.

What does the CASE statement do in SQL?Defines a new case for the databaseAdds a case to a tableAdds a condition to a queryAdds a new user to the database

Fill in the blank: A data professional uses the SQL _____ statement to return records that meet conditions by including an if/then statement in a query.1 pointCASEHAVINGWHENCONCAT

Difference between if-elseif-else and switch case. in table form

Which of the following statements is wrong?Question 7Select one:a.Aggregate functions are mostly used in the WHERE clause of a SELECT statement.b.When using the equivalence operator (=) in the predicate, you must make sure that the subquery retrieves exactly one value.c.SQL's concept of joining two or more tables also applies to joining two copies of the same table.d.Output of the COUNT() function is the number of rows or column values that would be selected by the query.

Case structures are used when the same variable is tested for many different values.TrueFalse