Write a SQL statement that will display product ID with alias "Prod_ID" and produ name with alias "Prod Name" only with price which is less than 10 OMR then arrange the product name in descending order. Table Name: Product Available Product_ID Product_Name Samsung Smart Quantity Price Category 100 170Electronic Yes

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
Questions 6
Write a SQL statement that will display product ID with alias "Prod ID" and product
name with alias "Prod Name" only with price which is less than 10 OMR then
arrange the product name in descending order
Table Name: Product
Product ID Product_Name
Quantity Price Category
Available
Samsung Smart
100
Phone
2
170Electronic Yes
200Electronic Yes
105Huwawei Tab
106Addidas Sport Shoes 10
4.
Yes
28Apparel
4Apparel
12appliances Yes
100Furniture
107Nike T-Shirt
0.
No
109Rice Cooker
1
No
101 Dining Table
0.3Beverage Yes
0.75Vegetable Yes
112Coke 250ml
150
25
113Brocolli
115Apple
25
0.2Fruits
Yes
Answer:
Transcribed Image Text:Write a SQL statement that will display product ID with alias "Prod ID" and product name with alias "Prod Name" only with price which is less than 10 OMR then arrange the product name in descending order Table Name: Product Product ID Product_Name Quantity Price Category Available Samsung Smart 100 Phone 2 170Electronic Yes 200Electronic Yes 105Huwawei Tab 106Addidas Sport Shoes 10 4. Yes 28Apparel 4Apparel 12appliances Yes 100Furniture 107Nike T-Shirt 0. No 109Rice Cooker 1 No 101 Dining Table 0.3Beverage Yes 0.75Vegetable Yes 112Coke 250ml 150 25 113Brocolli 115Apple 25 0.2Fruits Yes Answer:
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education