Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Which of the follow query can be used to find the name and ID of the products which have prices between 1 8 and 3

Which of the follow query can be used to find the name and ID of the products which have prices between 18 and 30(including 18 and 30)?
Select Product_Name, Product_ID
From Product
Where Product_Price>=18
And Product_Price<=30;
Select Product_Name, Product_ID
From Product
Where Product_Price is between 18 and 30;
Both A and B work.
Neither A nor B works.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

b. Where did they come from?

Answered: 1 week ago