For this question, refer to the schema of the PostgreSQL database for this course as needed.

Which results will show if the artist table is LEFT JOINed to the album table?

All artists, even those with no albums in the album table

All rows from the album table, even those that have NULL artist$\_$ids

Only rows from the artist table that do not have related albums in the album table

Only artists from the artist table that have albums