Count all artworks in the table moma.artworks whose author is unknown! Expected result:

HINT

First, create a double inner join of the tables moma.artworks, moma.artwork_artist and moma.artists to display the pairs title, name.

Then, replace the inner joins with left joins. As the last step, count the results where name is NULL.

Use a subquery so that the original query can be preserved.

For the joins, alias the tables for example as maw (artworks), mawat (artwork_artist) and mat (artist).

The subquery should end with WHERE mat.name IS NULL.

count 884