Question
write SQL queries to determine results for each of the following. 1. Select the ProductName for all products in Category 1 with a price less
write SQL queries to determine results for each of the following.
1. Select the ProductName for all products in Category 1 with a price less than $5.00.
2. Select the SupplierName for all suppliers from English-speaking countries (Australia, Canada, UK, USA)
3. Select the first and last names of all employees having a birthday in September.
4. Select the CustomerName and OrderID for all orders placed on 9 September 1996.
5. Select the ProductName for all seafood products with a supplier from 'Boston'.
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
Databases Illuminated
Authors: Catherine M. Ricardo, Susan D. Urban, Karen C. Davis
4th Edition
1284231585, 978-1284231588
