I'd like to combine customer and invoice in a view to make the Selecting Albums to Purchase project easier to answer, however, I am getting a syntax error when creating a view via the following code. Any thoughts? thanks :)
CREATE VIEW usa_customer AS
SELECT c.country, i.customer_id, i.invoice_id FROM customer c
WHERE c.country = "USA"
INNER JOIN invoice i ON c.customer_id = i.customer_id
SELECT * from usa_customer;