The SQL function LOWER('SQL Programming') returns:

The SQL function POWER(3, 4) returns:

What is the output of the following SQL query? This question is required.*SELECT LOWER('Hello, World!') AS Result;A"hello, world!" Data with column name ‘LOWER(‘Hello, World!’)’.B"HELLO, WORLD!"C"hello, world!" With column name ‘Result’D"H,e,l,l,o, ,W,o,r,l,d,!"

Given the string "Software Engineering", which SQL function returns the substring "Software"?

What is a function in SQL Server?

Evaluate this SQL statement:SELECT first_name, commissionFROM employeeWHERE commission =(SELECT commissionFROM employeeWHERE UPPER(first_name) = 'SCOTT');What would cause this statement to fail?Select one:a.All the given optionsb.The FIRST_NAME values in the database are in lowercase.c.There is more than one employee with the first name Scott.d.Scott has a zero commission value.e.Scalar function is not allowed in Subquery.