. Which manufacturers are located in the city of New York? Show the manufacturer's name, state, postal code, and contact person. 2. Show product information for white shoes in the 'sneakers' category that cost more than $50 and have a product description that begins with the letter "b" or "t". Show only the product name, its composition, and its list price. 3. Show the product name, description, and category for all shoes with a list price of $150 or more and in one of the following categories: sneakers, boots, or sandals. Order the output alphabetically by product name.
create table queries using sinplified sales table
1. Which manufacturers are located in the city of New York? Show the manufacturer's name, state, postal code, and contact person.
2. Show product information for white shoes in the 'sneakers' category that cost more than $50 and have a product description that begins with the letter "b" or "t". Show only the product name, its composition, and its list price.
3. Show the product name, description, and category for all shoes with a list price of $150 or more and in one of the following categories: sneakers, boots, or sandals. Order the output alphabetically by product name.
4. How many customers do we have with a last name starting with a 'Q' living in each city? Your query should display two columns, one named cust_num and one named city. Sort the results alphabeticaly by city.
5. Show the product name, list price, customer state (call it 'CustState'), and manufacturer state (call it 'ManState') for all products made by manufacturers in Connecticut (CT) and purchased by customers in New York (NY).
6. For green sandals, how does the current list price compare to the price at which products have sold? Show the product name, the
7. What is the total number of products sold by each manufacturer? Your query should display two columns, one named productnum and one named manufacturername. Sort the results alphabetically by manufacturername.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
