According to the “Orders" table below, which of the following will output the customers who made orders with OrderPrice larger than LO00 totally. Id OrderDate OrderPrice Customer 2009/12/12 |1000 2008/09/02 |1600 2008/09/02 700 2008/09/03 |300 2009/12/12 2000 2008/03/04 |100 |Henry Nina |Henry Henry Jhonson Nina O SELECT Customer,SUM(OrderPrice) FROM Orders GROUP BY Customer WHERE SUM(OrderPrice)>1000 O SELECT Customer,SUM(OrderPrice) FROM Orders GROUP BY Id WHERE SUM(OrderPrice)>1000 O SELECT Customer,SUM(OrderPrice) FROM Orders GROUP BY Customer HAVING SUM(OrderPrice)>1000 O SELECT Customer,SUM(OrderPrice) FROM Orders GROUP BY OrderPrice HAVING SUM(OrderPrice)>1000

According to the “Orders" table below, which of the following will output the customers who made orders with OrderPrice larger than LO00 totally. Id OrderDate OrderPrice Customer 2009/12/12 |1000 2008/09/02 |1600 2008/09/02 700 2008/09/03 |300 2009/12/12 2000 2008/03/04 |100 |Henry Nina |Henry Henry Jhonson Nina O SELECT Customer,SUM(OrderPrice) FROM Orders GROUP BY Customer WHERE SUM(OrderPrice)>1000 O SELECT Customer,SUM(OrderPrice) FROM Orders GROUP BY Id WHERE SUM(OrderPrice)>1000 O SELECT Customer,SUM(OrderPrice) FROM Orders GROUP BY Customer HAVING SUM(OrderPrice)>1000 O SELECT Customer,SUM(OrderPrice) FROM Orders GROUP BY OrderPrice HAVING SUM(OrderPrice)>1000

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter11: Group Functions

Section: Chapter Questions

Problem 14MC

See similar textbooks

Similar questions

Table : PURCHASE_ORDER ORDER_NO AMOUNT ORDER DATE CUSTOMER_ID SALESMAN_ID DELIVERY DATE 1001 300 05-03-2017 2001 3001 05-05-2017 1002 200.20 10-07-2017 2002 3003 10-10-2017 1003 600 12-06-2017 2005 3002 12-08-2017 1004 400.25 10-05-2017 2003 3004 10-07-2017 1005 500.10 03-08-2017 2004 3005 03-05-2017 1006 400 10-07-2017 2005 3006 10-10-2017 Table: PURCHASE _DETAILS ORDER_NO PRODUCT_NAME PRICE QUANTITY 1001 KEYBOARD 56 100 1002 MONITOR 36 200 1003 MOUSE 100 1004 HARD_DISK 58 300 1005 RAM 25 500 1007 CABINET 100 a) Write a SQL query to display PRODUCT_NAME, ORDER DATE and find number of years between the DELIVERY_ DATE from the CURRENT DATE [Hint: Use ON Clause]. b) Write a SQL query to display matched records from PURCHASE_ORDER table and all records from PURCHASE_DETAILS. c) Write an SQL query to display ORDER_NO, PRODUCT_NAME from table ORDER_DETAILS of products where the price is less than average price of products. [Hint: Use Subquery]. d) Write an SQL query to display ORDER_NO,…
answer the following
List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron. Use an INTERSECT operator. table name is:ORDER_LINEORLN_ORDER_NUMBER ORLN_PART_NUMBER ORLN_NUMBER_ORDERED ORLN_QUOTED_PRICE tablename is ORDER_TABLE ORDR_ORDER_NUMBER ORDR_ORDER_DATE ORDR_CUSTOMER_NUMBER tablename is CUSTOMER CUST_NUMBERCUST_LAST CUST_FIRST CUST_STREET CUST_CITY CUST_STATE CUST_ZIP_CODE CUST_BALANCE CUST_CREDIT_LIMIT CUST_SALES_REP_NUM tablename is PART PART_NUMBER PART_DESCRIPTION UNITS_ON_HAND ITEM_CLASS WAREHOUSE UNIT_PRICE tablename is SALES_REP SLSR_PKSLSR_LAST SLSR_FIRST SLSR_STREET SLSR_CITY SLSR_STATE SLSR_ZIP_CODE SLSR_TOTAL_COMMISSION SLSR_COMMISSION_RATE SELECT ORDR_ORDER_NUMBER, ORDR_ORDER_DATEFROM ORDER_TABLEWHERE ORDR_ORDER_NUMBER IN (SELECT ORLN_ORDER_NUMBERFROM ORDER_LINEWHERE ORLN_PART_NUMBER IN (SELECT PART_NUMBERFROM PARTWHERE…
Display all customers regardless of orders and also display orders for each customer.
Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
Write SQL Queries for following Emp table :EMPLOYEE_IDName EMAILHIRE_DATESALARYDEPARTMET 1001 Juniad Juniad@abc.com 2010-06-18 110000.00 CS1002 Irfan Irfan@abc.com 2011-04-16 100000.00 Sales1003 Hassan Hassan@abc.com 2010-03-08 88000.00 Marketing1004 Fahad Fahad@abc.com 2013-01-28 90000.00 Sales1005 Husnain Hus@abc.com 2012-01-28 55000.00 ES 5. Write a query to get the total salaries payable to employees.6. Write a query to get the maximum, minimum, sum, average salary and number of employees from emp table.7. Write a query to find name whose name Start with ‘H’ and 'J'.8. Write a query get all names from employees table in upper case.9. Write a query to select first 2 records from a table.10. Write a query to get the name of employees ends with character ‘N’. Such as Hassan etc.11. List all employee and add 500 to their salaries, also change the column heading to Salary WithBonus.12. Show all records whose salary is more than 55000.00 and less than 100000.00 Plz give me all ans
The table below lists customer/car hire data. Each customer may hire cars from various outlets. A car is registered at a particular outlet and can be hired out to a customer on a given date. carReg make model custNo custName hireDate outletNo outletLoc M565 OGD Ford Escort C100 Smith, J 14/5/98 01 Bearsden M565 0GD Ford Escort C201 Hen, P 15/5/98 01 Bearsden N734 TPR Nissan Sunny C100 Smith, J 16/5/98 01 Bearsden M134 BRP Ford Escort C313 Blatt, O 14/5/98 02 Kelvinbridge M134 BRP Ford Escort C100 Smith, J 20/5/98 02 Kelvinbridge M611 OPQ Nissan Sunny C295 Pen, T 20/5/98 02 Kelvinbridge The table shown above is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table.
Name the candidate keys in the following table: Student L number Student Name Student_SS_Number Student_Address Student City Student State LO005485 Leigh 811-47-4449 5744 KENSINGTON Ave. Boston MD LO004812 Tammy 441-79-7448 30936 OAK Alley Colorado Springs TX LO004415 Alfredo 375-78-2633 5115 BOWEN St. Kansas City VT LO003478 Ramona 360-82-2835 5097 HUBBARD LOWER Blvd. Miami PA LO003058 Crystal 528-16-2635 73192 RANDOLPH SUB Dr. Riverside MD LO004588 Angie 765-16-4433 5115 GROVELAND PARK Dr. Cincinnati FL L0005484 Tonya 410-76-3632 5115 BISHOP FORD Blvd. Irving MS LO003161 Preston 451-47-2634 95289 MONROE Ave. Boston NC HTM B I A - A - I E E E E E X X, E E D T T 12pt Paragraph
In the sql oracle application List the employees that HAVEchanged their jobs at least once.
Explain the concepts from the figure.
SQL StayWell’s marketing team requested the largest three properties currently in the system. You need to sort the properties by square foot information and get the top three for the marketing team.
Which product is ordered most frequently?