HackerRank Python Coding Challenge | Dataford Interview Questions

How would you handle three coding questions on HackerRank where you have to use Python?

For the SQL version, use the supplied HackerRank assessment tables to summarize candidates who attempted all three required questions. Include candidates even when some submissions failed, and treat multiple submissions to the same question as one attempted question.

Output

One row per candidate who attempted all three required questions.
Return candidate_name, attempted_questions, solved_questions, and average_passed_runtime_ms.
Sort by solved_questions descending, average passed runtime descending with NULL values last, then candidate_id ascending.

Schema

candidates

Column	Type	Description
candidate_idPK	INT	Unique candidate identifier
candidate_name	VARCHAR(100)	Candidate display name
email	VARCHAR(150)	Candidate email address

questions

Column	Type	Description
question_idPK	INT	Unique question identifier
question_number	INT	Question position in the assessment
title	VARCHAR(150)	Question title

submissions

Column	Type	Description
submission_idPK	INT	Unique submission identifier
candidate_id	INT	Candidate who submitted the solution
question_id	INT	Question being answered
status	VARCHAR(20)	Submission result, such as Passed or Failed
runtime_ms	INT	Execution runtime in milliseconds

Your question is HackerRank Python Coding Challenge. Start with the requirements and the three tables 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