Code RoomAuthors who have never commented
MediumPrep Room Coding #5091

Authors who have never commented

SQLAlgorithms & data structuresMid~10 min

Find authors with no comments to their name. 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 10 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.