Question: Oracle SQL Question: Write a query that displays the category_name, product_name and list_price of all products whose list price is less than the average list

Oracle SQL Question:

Write a query that displays the category_name, product_name and list_price of all products whose list price is less than the average list price for all products in its same category.

Sort the results by category_name in ascending sequence, then list_price in descending sequence

Statements must have at least one subquery (except as indicated), and use explicit join syntax, without relying on the USING or NATURAL keywords.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

LAB OVERVIEW Scenario and Summary Lab 6 will introduce the concept of group functions and subqueries to meet more complex report requirements. This lab will be completed using ACCESS and the...

Using the tables below, answer the following questions in a Word document. Show both the SQL statement and the results (output and messages). Edit the final exam file and put your answers in the file...

Lab Table : Let's use the EmployeeHours table to illustrate how SQL IN works: Date Hours 5/6/2004 8 Employee John Smith Allan Babel Tina Crown John Smith 5/6/2004 8 8 8 5/6/2004 5/7/2004 9 Allan...

Write store procedure called factorial that gets an integer number n and calculates and displays its factorial. You must use RECURSION to calculate the results. Example: 0! = 1 1! = fact(1) = 1 2! =...

In Oracle SQL DEVELOPER : Write a SQL query to display product name and list price for product in category 1 which have the list price less than the lowest list price in ANY category. Sort the output...

1. Write a database description for each of the relations shown, using SQL DDL. 2. Write SQL data definition commands for each of the following queries: a) How would you add an attribute, country...

This assignment contains ten exercises, each worth ten points, for a total of one hundred points possible. Use the Northwind database, hosted at the W3Schools Web site located at w3schools.com. For...

/* It is your responsibility to provide a meaningful column name for the return value of the function. These statements will NOT use GROUP BY or HAVING. Those keywords are introduced in the next...

SQL Query Question. Use the PVFC database if you have it. These are my notes: RETRIEVE ALL COLUMNS AND ROWS select * from product_t select * from employee_t select * from order_t RETRIEVE INDIVIDUAL...

Hi, I am working on SQL in Oracle APEX database system. I am stuck on question 1 and question 4. I was wondering if you can just show the answer. I have tried several different ways and still appear...

What are fixed prices? What do customers like about fixed prices? What do retailers like about fixed prices?

The owner of a moving company wanted to predict labor hours based on the cubic feet moved. Perform a residual analysis for these data (stored in Moving). Based on these results, evaluate whether the...

Sometimes as a firem may allocate aportion of period variance to the work in process inventory account true or false

2. (10 pts) The following table shows a portion of the memory of a computer. All numbers in the table are in hexadecimal. Address Contents Ox52000040 12 Ox52000041 23 Ox52000042 34 Ox52000043 FF...

4. According to the Solow model, if an economy increases its saving rate, then in the new steady state, compared with the old one, the marginal product of capital will be and the growth rate will be...

2. An economy without population growth or technological progress has the production function y = 20k1/2. The current capital stock is 100, and the depreciation rate is 12 percent. For income per...

6. If the economy has more capital than in the Golden Rule steady state, reducing the saving rate will steady-state income and steady-state consumption. a. increase, increase b. increase, decrease c....