hi i just want to ask a bout this: 2. Get least expensive product name and price how can  i do that

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
100%

hi

i just want to ask a bout this:

2. Get least expensive product name and price

how can  i do that 

Given SQL Tables below:
Table Name: Products
Table Name: ProductsPrice
ProductID ProductName
Apple
Banana
ProductID
ProductPrice
1
1
10.0
2
2
2.1
3
Cucumber
3
5.5
4
Watermelon
4
20.0
Ice-cream
0.5
Orange
Eggplant
Egg
6
0.8
7
7
2.0
8
8
40.0
Write SQL Queries to get the following:
1. Count number of products
2. Get least expensive product name and price
3. Count number of products with price less than 5
Transcribed Image Text:Given SQL Tables below: Table Name: Products Table Name: ProductsPrice ProductID ProductName Apple Banana ProductID ProductPrice 1 1 10.0 2 2 2.1 3 Cucumber 3 5.5 4 Watermelon 4 20.0 Ice-cream 0.5 Orange Eggplant Egg 6 0.8 7 7 2.0 8 8 40.0 Write SQL Queries to get the following: 1. Count number of products 2. Get least expensive product name and price 3. Count number of products with price less than 5
Expert Solution
steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY