Which of the following statements is valid? (refer to the tables in the JustLee Books database.)a. SELECT title FROM booksWHERE retail<(SELECT cost FROM booksWHERE isbn = '9959789321');b. SELECT title FROM booksWHERE retail = (SELECT cost FROM booksWHERE isbn = '9959789321' ORDER BY cost);c. SELECT title FROM booksWHERE category IN (SELECT cost FROM orderitemsWHERE isbn = '9959789321');d. none of the above statements

Which of the following statements is valid? (refer to the tables in the JustLee Books database.)a. SELECT title FROM booksWHERE retail<(SELECT cost FROM booksWHERE isbn = '9959789321');b. SELECT title FROM booksWHERE retail = (SELECT cost FROM booksWHERE isbn = '9959789321' ORDER BY cost);c. SELECT title FROM booksWHERE category IN (SELECT cost FROM orderitemsWHERE isbn = '9959789321');d. none of the above statements

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter9: Joining Data From Multiple Tables

Section: Chapter Questions

Problem 16MC

See similar textbooks

Similar questions

How do you indicate that a column alias should be used?
Which of the following SQL statements is invalid and returns an error message? ALTER TABLE books ADD CONSTRAINT books_pubid_uk UNIQUE (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_pk PRIMARY KEY (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_nn NOT NULL (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_fk FOREIGN KEY (pubid) REFERENCES publisher (pubid); All of the above statements are invalid.
INPUT TABLE You're given a orders table and the columns in the orders table are shown below: Orders Order_Id INT Type VARCHAR(10) Red_Shipping_ Days INT Scheduled_Shipping_Days INT Customer_Id INT Order _city VARCHAR(20) Order_Date DATE Order_Region VARCHAR(15) Order_State VARCHAR(20) Order _Status VARCHAR(20) Shipping_Mode VARCHAR(20) QUERY Calculate count of all the orders. Where Order_ State is Maharashtra Note - Use the alias of oc for count of orders Group the results by Type Order them by oc in ascending order. OUTPUT COLUMNS oc, Type
Which of the following statements is correct? (refer to the tables in the JustLee Books database.)a. The IN comparison operator can’t be used with a subquery that returns only one row of results.b. The equals (=) comparison operator can’t be used with a subquery that returns morethan one row of results.c. In an uncorrelated subquery, statements in the outer query are executed first, and thenstatements in the subquery are executed.d. A subquery can be nested only in the outer query’s SELECT clause.
In The SQL Oracle Application Using the UNION operator, write a query that displays the employee_id, job_id, and salary of ALL present and past employees. If a salary is not found, then just display a 0 (zero) in its place.
The tblCities table contains a numeric field named Population. Which of the following LINQ statements calculates the total population of all the cities in the table?a. Dim intTotal As Integer = Aggregate city In CitiesDataSet.tblCities Select city.Population Into Sum()b. Dim intTotal As Integer = Sum city In CitiesDataSet.tblCities Select city.Population Into totalc. Dim intTotal As Integer = Aggregate CitiesDataSet.tblCities.city Select city.Population Into Sum()d. Dim intTotal As Integer = Sum city In CitiesDataSet.tblCities.population
Write a SELECT statement that uses a correlated subquery to return one row per customer, representing the customer's oldest order (the one with the earliest date). Each row should include these five columns: first_name last_name order_id order_date total quantity Include only orders with a total order quantity greater than 2. Subject: MySQL
Which of the following SELECT statements will select the ProdNum field from the Products table, and then sort the records in descending order by the Price field? a. SELECT ProdNum FROM Products WHERE Price DESC b. SELECT ProdNum FROM Products ORDER BY Price DESC c. SELECT ProdNum FROM Products SORT Price DESC d. SELECT ProdNum FROM Products ORDER BY ProdNum DESC
The COUNT(*) function in the SELECT clause is used to return:a. the number of records in the specified tablesb. the number of orders placed by each customerc. the number of NULL values in the specified tablesd. the number of customers who have placed an order
Use multiple-row subquery in a WHERE clause. List order numbers of books, written by an author whose author ID is J100, that were ordered by the customers. Include the following columns in the result. a. Order Numberb. ISBNc. QuantityHint: In this task, we will compare the list of books in the subquery with the list of books in the outer query. The subquery returns ISBN of books that were written by the author J100. The outer query returns all order records (each record contains order number, ISBN, and quantity)
Which of the following statements is correct? (refer to the tables in the JustLee Books database.)a. The WHERE clause can contain a group function only if the function isn’t also listed in the SELECT clause.b. Group functions can’t be used in the SELECT, FROM, or WHERE clauses.c. The HAVING clause is always processed before the WHERE clause.d. The GROUP BY clause is always processed before the HAVING clause.
Write a SELECT statement that returns two columns basedon the EMPLOYEES table. Contact, is the employeelastname and the first initial of the first name. The secondcolumn, Phone, is the homephone without the area code.Only return rows for those employees in the 206 areacode, sort the results by the last name.