Data Analyst Online Test Prep | Dataford Interview Questions

How would you prepare for an online test that includes Python and SQL questions in 1.5 hours?

You are given a short list of topics and a time budget. Write a SQL query that returns the topics to study first, ordered by priority and then by topic name. Ignore any topic with a NULL priority.

Output

One row per topic with a non-NULL priority
Columns: topic, priority
Sort by priority descending, then topic ascending

Schema

study_topics

Column	Type	Description
topic_idPK	INT	Unique topic identifier
topic	VARCHAR(100)	Study topic name
priority	INT	Priority score for study ordering

Your question is Data Analyst Online Test Prep. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem