guitar sql
Using our my_guitar_shop database:
Write a query to list Customer_id, email_address, last_name and shipping_address_id for all customers that use gmail as their email.
Using our my_guitar_shop database:
Write a query to find all orders that were paid with a VISA credit card and where the ship_amount is equal to $5.
Put the result in order by the card expiration.
Write a query to list customer_id, city, state, zip_code and phone for all customers that are not in the state of New York or New Jersey.
Modify the previous query to display the city and state as one field. Give it a meaningful label.
Write a query to display all the products for our shop but display the date_added field in the DD-Mon-YYYY format
