Answer to Question #136255 in MatLAB for Samantha

Question #136255

These are queries that use the full Red Cat Database as shown in Figure 3.1. You must use the full Red Cat tables of Customer, Sale, SaleItem, Product, Manufacturer, and Employee tables.


For each information request below, formulate a single SQL query to produce the required information.



1. Show the product name, city, and state for all manufacurers located in New York (NY), Oklahoma (OK), Florida (FL). Order alphabetically (ascending) by state and then product name. 


2. Show the customer first name, last name, city and state for all in San Francisco and San Diego. Include customers from California where city begins with letter A.


3. Which customer lives in city New York? First name, last name, city, phone number.


4. Show the customer's first name, customer's last name, customer's city ('CustCity'), product name, list price for all products made by manufacturers in Arizona and purchased by customers in Oklahoma City or Tulsa.


1
Expert's answer
2020-10-01T16:47:35-0400
Dear Samantha, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS