-- Finance is doing an audit and has requested a list of each customer in the -- different states. -- They want the state_name, state_abbr, and company_name for all customers in the U.S. -- -- If a state has no customers, still include it in the result with a NULL -- placeholder for the company_name. -- In this case, the us_states table will be the left-side table, and the -- customers table will be the right-side table. -- Consider what type of JOIN you will need in order to include results where the -- right-side table has NULL values. (It's not an inner JOIN this time!)

SELECT state_name, state_abbr, company_name
FROM us_states
LEFT OUTER JOIN customers
ON us_states.state_abbr = customers.state