In the table moma.artists, find all artists who do not have any artwork in the database! Look for missing artwork_id in the table moma.artwork_artist. Sort the names of the artists by their last name. Use the last word in the text string name: Given the heterogeneity of the data, that's as close to a last name as it gets. Skip the first 7 rows which are organizations rather than individual artists. Expected result:

Hint: In the ORDER BY clause, use REGEXP_REPLACE(name, '(.*) +(.*)', '\2 \1') instead of name.

Create the left outer join of the tables moma.artists and moma.artwork_artist.

Filter all rows where artwork_id is NULL.

At the end use OFFSET 7.

\begin{tabular}{ll|l} name & artwork_id \\ Aino Aalto & id \\ Martine Aballea & NULL \\ Jussuf Abbo & NULL \\ Adolf Abel & NULL \\ Ljungberg's Textile AB & NULL \end{tabular}