Question: Write a SQL query to print the item name, item type and price of all the items present in both the shops in descending order

Write a SQL query to print the item name, item type and price of all the items present in both the shops in descending order of their price.
Tables Schema as Below:
shop_1
columnName dataType
item_id INT
item_name VARCHAR(255)
item_type VARCHAR(255)
price INT
shop_2
columnName dataType
item_id INT
item_name VARCHAR(255)
item_type VARCHAR(255)
price INT

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!

Q:

A word document consisting of: Your SQL statements written as text where I can test your work by copying and paste your statement into the SQL server. Standard size (not small) screen capture for...

Q:

Given the following database, please answer the following 6 - 4 7 . Modify P&E 6 - 4 6 to include only those product lines the average price of which is higher than $ 2 0 0 . 6 - 4 8 . List the names...

Q:

Question 27 (90 points) Please consider the following relational database tables. Primary keys are underlined, and foreign keys are marked with an asterisk. - Date format: MM/DD/YYYY, for example,...

Q:

the subject is Data base and we are using oracle Answer ALL Questions The relational schema below shows the partial database of J&M Sales Corporation. The primary keys are in bold and foreign keys...

Q:

DATABASE SYSTEM CLASS: Please help me: 1. Define a view named ItemOrder. It consists of the item number, description, price, order number, order date, number ordered, and quoted price for all order...

Q:

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

Q:

Database Design Report and Implementation - Please ignore requirement for screenshot, just need assistance with the actual SQL queries so I can insert them into the data myself for the output....

Q:

At Bird Company, an order is recorded in two separate tables as follows. The table titled orders contains a single record of header information for each order in the following fields: order number...

Q:

Using the PSQL function in a linux terminal solve. PART2 Provide solutions with screenshots please show everything. I will like pls solve Heres a txt file that you can use for test...

Q:

Question Three [30 marks] Ahalia sports club stores information about the sports activities they conduct regularly. The members of the club use items such as helmets, pads etc. supplied by the...

Q:

On January 4, 2014, Ambers Boutique paid cash of $95,000 for a 10-year franchise. Prepare the entry to record the purchase of the franchise and the adjusting entry at December 31, 2014.

Q:

How do fraud considerations relate to the auditors materiality decision?

Q:

??????????????equipment 1000000 Accounting by a joint operator Records of Heads Ltd Heads Ltd contributed equipment which had a carrying amount of $1,000,000, and a fair value of $1,500,000. The...

Q:

Chicago Southern, founded in 1954 and located at the edge of the University of Illinois at Chicago Circle, is a privately owned 473 patient bed hospital. Close to upscale, gentrified downtown...

Q:

Make efficient use of your practice time?

Q:

How do you react when you hear speakers with an accent that is different from yours? Do you find them difficult to understand, or do you make assumptions about them based on the way they speak? How...

Q:

Have you ever had an embarrassing public speaking moment? What did you do? Did it affect your confidence level or your perception of your own competence? Now compare this to how you reacted to...