Which of the following statements would create a UNION between all of the countries we have customers, employees, or invoices in? SELECT country FROM invoice UNION SELECT country FROM customer UNION SELECT country FROM employee; SELECT billing_country FROM invoice SELECT country FROM customer SELECT country FROM employee UNION; SELECT billing_country FROM invoice SELECT country FROM customer SELECT country FROM employee; SELECT billing_country FROM invoice UNION SELECT country FROM customer UNION SELECT country

Which of the following statements would create a UNION between all of the countries we have customers, employees, or invoices in? SELECT country FROM invoice UNION SELECT country FROM customer UNION SELECT country FROM employee; SELECT billing_country FROM invoice SELECT country FROM customer SELECT country FROM employee UNION; SELECT billing_country FROM invoice SELECT country FROM customer SELECT country FROM employee; SELECT billing_country FROM invoice UNION SELECT country FROM customer UNION SELECT country

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter11: Group Functions

Section: Chapter Questions

Problem 6MC

See similar textbooks

Similar questions

Which of the following is not a valid SELECT statement? SELECT lastname, firstname FROM customers; SELECT * FROM orders; Select FirstName NAME from CUSTOMERS; SELECT lastname Last Name FROM customers;
Which of the following SELECT statements displays a list of customer names from the CUSTOMERS table? SELECT customer names FROM customers; SELECT “Names” FROM customers; SELECT firstname, lastname FROM customers; SELECT firstname, lastname, FROM customers; SELECT firstname, lastname, “Customer Names” FROM customers;
Which of the following is a valid SQL statement? SELECT * WHERE amid = ‘J100’ FOR UPDATE; INSERT INTO homeworkl0 VALUES (SELECT * FROM acctmanager); DELETE amid FROM acctmanager; rollback; all of the above
Which of the following is not a valid SELECT statement?a. SELECT STDDEV(retail)FROM books;b. SELECT AVG(SUM(retail))FROM ordersNATURAL JOIN orderitems NATURAL JOIN booksGROUP BY customer#;c. SELECT order#, TO_CHAR(SUM(retail), '999.99')FROM orderitems JOIN books USING(isbn)GROUP BY order#;d. SELECT title, VARIANCE(retail-cost)FROM booksGROUP BY pubid;
Which of the following queries identifies other customers who were referred to JustLee Books by the same person who referred Jorge Perez?a. SELECT customer# FROM customersWHERE referred = (SELECT referred FROM customersWHERE firstname = 'JORGE'AND lastname = 'PEREZ');b. SELECT referred FROM customersWHERE (customer#, referred) = (SELECT customer#FROM customers WHERE firstname = 'JORGE'AND lastname = 'PEREZ');c. SELECT referred FROM customersWHERE (customer#, referred) IN (SELECT customer#FROM customers WHERE firstname = 'JORGE'AND lastname = 'PEREZ');d. SELECT customer# FROM customersWHERE customer# = (SELECT customer#FROM customers WHERE firstname = 'JORGE'AND lastname = 'PEREZ');