Multiple Choice
Based on the code above,list the number and name of all customers that are either represented by sales rep 30 or that currently have orders on file,or both.
A) SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer ;
B) SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders WHERE Customer.CustomerNum=Orders.CustomerNum ;
C) SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' WHERE Customer.CustomerNum=Orders.CustomerNum ;
D) SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders ;
Correct Answer:

Verified
Correct Answer:
Verified
Q40: A WHERE and a HAVING clause cannot
Q53: You use the SQL _ command to
Q62: In SQL,you sort data using the _
Q64: Based on the code above,list the complete
Q65: The _ clause can be used to
Q66: Based on the code above,find how many
Q68: When used after the word SELECT,the _
Q69: When you use a name containing a
Q70: The _ data type stores integers,but uses
Q72: When you need to sort data on