Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started
SQL Top Validated Bugs
00:00
5 left

SQL Top Validated Bugs

MediumSQL · PostgreSQL

Problem

Write a SQL query to find the top 5 testers who submitted the most validated bugs in the last quarter for Applause.

Use the provided tester and bug records. Consider the last quarter relative to the current date.

Output

  1. One row per qualifying tester with tester_name and validated_bug_count.
  2. Include only validated bugs submitted during the previous calendar quarter.
  3. Sort by validated_bug_count descending, then tester_name ascending for ties, and return at most five rows.

Schema

testers
ColumnTypeDescription
tester_idPKINTUnique identifier for the tester
tester_nameVARCHAR(100)Display name of the tester
bugs
ColumnTypeDescription
bug_idPKINTUnique identifier for the bug submission
tester_idINTTester who submitted the bug
submitted_atDATEDate the bug was submitted
validation_statusVARCHAR(30)Validation state of the submitted bug
Tablestestersbugs
Interviewer

Your question is SQL Top Validated Bugs. Start with the requirements and the two 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.

You need to log in / sign up to run or submit.
CodePostgreSQL
You need to log in / sign up to run or submit.Ln 1
Run your query to see results here.