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 query. 

Answer options:

A. ORDER BY "Last name"
B. ORDER BY 2, cust_id
C. ORDER BY CUST_NO
D. ORDER BY 2, 1
E. ORDER BY "CUST_NO"

ABD

Using the ORDER BY Clause in Set Operations -The ORDER BY clause can appear only once at the end of the compound query. -Component queries cannot have individual ORDER BY clauses. -The ORDER BY clause recognizes only the columns of the first SELECT query. -By default, the first column of the first SELECT query is used to sort the output in an ascending order.