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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Write SQL queries to determine results for each of the following. 1. Select the CustomerName and OrderID for all customers who ordered 'Aniseed Syrup', sorted in alphabetical order. 2. Select the...

Q:

Write the OUTPUT of the following SQL Statement: 1- SELECT brand FROM products WHERE price = 2.2; Answer...

Q:

Write SQL queries for the following scenarios and retrieve required information from the "MySql" database tables "Passenger" & "Price" 1. How many Female and how many male passengers travelled for a...

Q:

I need help making the SQL statements in visual studio 2017 Please read homework carefully svxGS0201 9 1 0/Project%20Task%2075628 1 %29.pdf MGMT 329: Database Management Project Task 7: Requi The...

Q:

Its management information systems Please follow up all the information whatever is mention. The purpose of the project is to manipulate tables and write SQL queries in order to extract various...

Q:

I need help with this SQL I keep getting error the information is not found. These are queries that use the full Red Cat Database as shown in Figure 3.1. To do these queries you cannot use the...

Q:

This is only one question. **I need from query 8 forward.**Tables from last project start from the Vendor table until the Supply table. Only need from query 8 forward**. Tables from last project...

Q:

Create tables as described with sample data, and then write SQL queries for the given problems. Note your confidence levels for each SQL query on a scale of [0, 10]. */ DROP TABLE Printer CASCADE...

Q:

For the Pizza Delivery Shop DB, (see Appendix), write SQL queries to answer each of the following questions. a) List all the last names, phone numbers and zip codes of the customers. b) List...

Q:

Part 3: On your own Profile the following table in the Northwind Traders Database. The first two have been done for you in the previous part. Table Type Row Business Key One Row is Count Employees...

Q:

Which of the following series are conditionally convergent? arctan n n=1 (ii) (-1y"-1 Vn +1 n=1 (-1)"+1 In n n=2 (iii) E (A) (i) and (ii) only (B) (iii) only (C) (ii) only (D) (ii) and (iii) only (E)...

Q:

If Valuation Allowance for Trading Investments has a credit balance, how is it treated on the balance sheet?

Q:

Help Save & Exit Submit Which FICO credit score would represent the least risky borrower? Multiple Choice 4 0 0 7 0 0 5 5 0 8 2 5 6 2 5

Q:

Strategic Planning: How do you develop and implement a strategic plan for your business? - What factors do you consider when setting long - term goals? How do you assess and respond to changes in the...

Q:

=+7. Compare Walmarts new and old logos:

Q:

=+1. Why is it important to view CSR from a strategic context?

Q:

=+2. Why are large multinational firms more likely to be concerned about CSR?