Archive Database Step 3: Ranked Answers

Write three ranked queries: the most recent books, the authors with the most copies held, and the oldest book per country. Each must have an ORDER BY that makes the ranking real, and each must include a tiebreaker so the result is stable when two rows tie. Then run each twice and confirm you get the identical result both times. A query whose answer changes between runs is not an answer.

SANKOFA SANDBOX
loading editor…
Your turn → Work through it step by step. This is a piece of the course project, not a throwaway exercise.

Built it in both languages?

Mark it done once your Python and JavaScript versions both run correctly. Honesty here is what makes the dashboard useful to you.

← BackNext: Module 4: NULL →