my-guitar-shop-database-exersices/Exercise_2.2.sql

SELECT 
    c.first_name AS First,
    c.last_name AS Last,
   a.line1 AS line1,
   a.city AS city,
   a.state AS state,
   a.zip_code AS Address
FROM
    customers c
        INNER JOIN
    addresses a ON c.customer_id = a.customer_id
WHERE
    c.email_address = 'allan.sherwood@yahoo.com'
ORDER BY Last, First;