Which three statements are true regarding the WHERE and HAVING clauses in a SQL statement? (Choose three.) A. WHERE and HAVING clauses cannot be used together in a SQL statement. B. The HAVING clause conditions can have aggregate functions. C.…

Evaluate the following SQL statement: SQL> select cust_id, cust_last_name "Last name" FROM customers WHERE country_id = 10 UNION SELECT cust_id CUST_NO, cust_last_name FROM customers WHERE country_id = 30 Identify three ORDER BY clauses either one of which can complete the…