Question
Hello i need some help with a SQL database. Pull all the attributes of the product with product ID greater than five, CategoryID equal to
Hello i need some help with a SQL database.
Pull all the attributes of the product with product ID greater than five, CategoryID equal to four, and price greater than $10 from the products table.
Show SupplierID AND SupplierName of suppliers with (A) SupplierID greater than OR equal to two but smaller than ten OR (B) country equal to USA [Use WHERE OR]
Show SupplierID AND SupplierName of suppliers with SupplierID greater than 2 but smaller than 10 [Use WHERE BETWEEN AND]
Show SupplierID AND SupplierName of suppliers with SupplierID equal to two, four, or eight. [Use WHERE OR]
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started