Code RoomAuthors missing country
EasyPrep Room Coding #5094

Authors missing country

SQLAlgorithms & data structuresEntry–Mid~8 min

List authors whose country is missing. Return `name`, alphabetically.

What a strong answer looks like

Say what the query is meant to return before you write it, and name the shape of the answer: how many rows, grouped by what. Then watch the NULLs and the duplicates, because that is where most of these are lost.

Run onlyA query runs as one statement, so there is nothing to step through. Run it and read the rows.

0:00 of about 8 min

Expected, in this order

name
Quin

Your result

Run your query to compare.

1 more set of rows are waiting. Free with an account.