Write an SQL query to extract the answer directly. TablespatientColumnsPatientIDGenderAgeIndexesForeign KeysTriggersvisitColumnsVisitIDPatientIDVisitReasonUrgencyArrivalModeHospAdmitCostArrivaldateDischargedateIndexesForeign KeysTriggers Get a list of visit reasons of which the average cost is greater than 2000 but less than 2050.• Report the visit reason with the average cost (i.e., the result table should contain twocolumns.)• Name the average cost column as avgcost.Sort the result table by average cost in descending order.

The SQL Query to extract the given output is: SELECT VisitReason, AVG(Cost) AS “avgcost” FROM visit…

Get a list of visit reasons of which the average cost is greater than 2000 but less than 2050. • Report the visit reason with the average cost (i.e., the result table should contain two columns.) • Name the average cost column as avgcost. Sort the result table by average cost in descending order.

Get a list of visit reasons of which the average cost is greater than 2000 but less than 2050. • Report the visit reason with the average cost (i.e., the result table should contain two columns.) • Name the average cost column as avgcost. Sort the result table by average cost in descending order.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter11: Group Functions

Section: Chapter Questions

Problem 6HOA

See similar textbooks

Similar questions

A table can have a maximum of how many PRIMARY KEY constraints?
What guidelines should you follow when naming tables and columns in Oracle 12c?
Create a list showing only the EmployeeID, Sales, and Projected Sales sorted from highest to lowest amount for Sales
Based on the following table, please find the customers who locate in the same state. sales.customers *customer_id first_name last_name phone email street city state zip_code . Based on the following table, please display the staff and their corresponding manager in the same store. Please display staff’s full name in one column, manager’s full name in another column, and store_id. sales.staffs *staff_id first_name last_name email phone active store_id manager_id
Q#1 Print the name of players who played any tournament organized by “hafiz asif”. (Nested Queries)Q#2 Print the sponsors name and tournament name where sponsor name starts with “a”. (Inner Join)Q#3 Print the rank code of the tournament name “grand master”.Q#4 Find and display what type of rank players played in a tournament organized by omer khalid.Q#5 Print the name of the players and email who have started matches in 2002,2003 and 2004.(Nested queries
Provide a summary of customer balance characteristics for customers who made purchases. Include the minimum balance, maximum balance, and average balance, as shown in Figure P7.21.
2- selects the order line items (orderNumber, orderlinenumber) fromthe “orderdetails” table. Also, display the subtotal (quantityOrdered * priceEach) for eachline item and sorts the result set based on the subtotal descending .3- Display unique last names from employees table ordered by last name.4- Display customerNumber, customerName and creditLimit for getting the top five customerswho have the highest creditLimit.5- Find customer Name, customer country, sales representative employee number fromcustomers who do not have a sales representative.6- For each order status, display status and count of orders have this status.7- For Each order number in order details table, Display order number, sum of quantityordered (itemsCount) and sum of (priceEach * quantityOrdered) as total. With condition“total” greater than 1000.8- Display product code, product name and text description for product.9- Find customer number, customer name, order status and order number, for customerwith their orders…
Make a list of all course offerings. Provide the course code, start date, course duration, and trainer's name. 4.2 List the course code, start date, and number of attendees for all course offerings. Sort your results based on the number of attendees, from most to least. 4.3 Which workers took the same course more than once? 4.4 Provide the name of all trainers, the number of courses they taught, the total number of students in their classes, and the average assessment rating. The evaluation ratings should be rounded to one decimal place. 4.5 Who took the same courses as employee with eid = 2002?