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 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;

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter11: Group Functions

Section: Chapter Questions

Problem 20MC

See similar textbooks

Similar questions

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.
Which of the following statements retrieves data from the Sales table and stores it in the CompanyDataSet? Me.CompanyDataSet.Fill(Me.Sales) Me.SalesBindingSource.Fill(Me.CompanyDataSet) Me.SalesBindingNavigator.Fill(Me.CompanyDataSet.Sales) Me.SalesTableAdapter.Fill(Me.CompanyDataSet.Sales)
SELECT COUNT(INV_NUMBER) AS 'Total Invoices', SUM(TOTAL_PRICE) AS 'Total Sales', MIN(TOTAL_PRICE) AS 'Minimum Customer Purchases', MAX(TOTAL_PRICE) AS 'Largest Customer Purchases', ROUND(AVG(TOTAL_PRICE), 2) AS 'Average Customer Purchases'FROM (SELECT CUS_CODE, LINE.INV_NUMBER AS INV_NUMBER, ROUND(SUM(LINE.LINE_PRICE * LINE.LINE_UNITS), 2) AS TOTAL_PRICEFROM INVOICE, LINE WHERE INVOICE.INV_NUMBER = LINE.INV_NUMBER GROUP BY CUS_CODE, LINE.INV_NUMBERORDER BY CUS_CODE, LINE.INV_NUMBER)INVOICELINE; i use this code but it didn't show the same value as in the question
Which of the following calculates a 10% commission on the values in the Sales field and then stores the results in the Commission field? a. SELECT Year, Sales, Commission = Sales * 0.1 FROM dbo.TrentSales b. SELECT Year, Sales, AS Commission = Sales * 0.1 FROM dbo.TrentSales c. SELECT Year, Sales, Sales * 0.1 = Commission FROM dbo.TrentSales d. SELECT Year, Sales, Sales * 0.1 AS Commission FROM dbo.TrentSales
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 are equivalent to WHERE attribute IN (123, 200)? a. WHERE attribute BETWEEN 123 AND attribute = 200 b. WHERE attribute = 123 AND attribute = 200 c. WHERE attribute <= 123 AND attribute >= 200 d. WHERE attribute = 123 OR attribute = 200
a) Which one of the following queries finds sailors who havereserved at least a boat but not a red boat? Query1:SELECT R.sidFROM Boats B, Reserves RWHERE B.bid=R.bid AND B.color<>’red’ Query2:SELECT R.sidFROM Reserves REXCEPTSELECT R.sidFROM Boats B, Reserves RWHERE B.bid=R.bid AND B.color=’red’ b) What are the results of query1 and query2 in part A,considering the following instances of Sailors and Reserves tables? (images attached)
Changes this SQL query statement to Xquery Statements select distinct company_name from (employee natural join works) join company using (company_name) where employee.city = 'Omaha' or employee.city = 'Lincoln' select distinct street, employee.city from manages, employee natural join works where company_name = 'Union Pacific';
Question 9 Convert the following QUERIES to Stored Procedures with IN parameters In MySQL select customerNamefrom customerswhere customerNumber in(select customerNumberfrom orders where orderNumberin(select orderNumber fromorderdetails) ); Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
53. Which SELECT statement retrieves the customer name for those that have a salesperson number of 137? A: SELECT CUSTNAME FROM CUSTOMER WHERE SPNUM 137; B: SELECT* FROM CUSTNAME WHERE SPNUM=137; C: SELECT CUSTOMER FROM CUSTNAME WHERE SPNUM=137; D:SELECT* FROM CUSTOMER WHERE SPNUM=137
Which of the following commands is valid?a. RENAME customer# TO customernumber FROM customers;b. ALTER TABLE customers RENAME customer# TO customernum;c. DELETE TABLE customers;d. ALTER TABLE customers DROP UNUSED COLUMNS;
Write the SQL query to display the cid of all employees. Write the SQL code to list all administrators whose salary is greater than Rs 45000. Write the SQL query to set salary of all supervisors to Rs 40 000.Write the SQL query to display details of clients whose names end with character 'e'. Write the SQL code to display details of those clients who come from Vacoas or mahebourg. Write the SQL code to list details of clients in descending order of the salary. Write the SQL code to show details of clients whosere salary is greater than Rs 45000 and ageis between 35 and 45.