Loading...
Character Position in Endpoint
A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- junior
Problem
While debugging a routing issue, an engineer needs to locate where the letter 'a' first appears in each API endpoint string (case-insensitive). Show the endpoint and the character position, excluding endpoints that don't contain 'a' at all, ordered by call ID.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.