DataDriven
LearnPracticeInterviewDiscussDailyJobs

The Ones Nobody Calls

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain
SQL
Difficulty
medium
Seniority
L3

Problem

The API deprecation team is hunting for endpoints that barely see any POST traffic, the natural candidates for sunsetting. The method field is logged inconsistently, sometimes lowercase, so treat every casing of POST as the same request. Show the two lowest positions by POST call volume, quietest first, with each endpoint, its call count, and its position.

Summary

The POST paths the traffic forgot.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.

Related

  • All Practice Problems
  • Mock Interview Mode
  • SQL Interview Questions
  • Data Engineering Interview Prep Guide
  • Daily Challenge
  • Data Engineering Lessons