Customer CustID CustName Product Category Price Qty StorelD C1 Khamis Shoe Footwear 20 3 s1 C2 Sara Ring Jewelry 50 S2 C3 Mariyam Scarf Clothing 5 4 S1 C4 Mohammed Slipper Footwear 8 1 52 C5 Hiba Tshirt Clothing 25 1 S3 3.

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
icon
Concept explainers
Question
1. Write a query to display customer name, product and category with prices between 5 and 25 (without using between), save as q1. 2. Write a query to remove duplicate values from the category column of the customer table, save as q2. 3. Write a query to arrange the product price in descending order, save as q3.
Customer
CustID
CustName
Product
Category
Price
Qty
StorelD
C1
Khamis
Shoe
Footwear
20
3
S1
C2
Sara
Ring
Jewelry
50
S2
C3
Mariyam
Scarf
Clothing
5
4
S1
C4
Mohammed
Slipper
Footwear
S2
C5
Hiba
Tshirt
Clothing
25
1
S3
3.
1,
00
Transcribed Image Text:Customer CustID CustName Product Category Price Qty StorelD C1 Khamis Shoe Footwear 20 3 S1 C2 Sara Ring Jewelry 50 S2 C3 Mariyam Scarf Clothing 5 4 S1 C4 Mohammed Slipper Footwear S2 C5 Hiba Tshirt Clothing 25 1 S3 3. 1, 00
Expert Solution
steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Knowledge Booster
Query Syntax
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.
Similar questions
  • SEE MORE QUESTIONS
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