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

L3

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.

Summary

URL patterns, character by character.

Practice This Problem

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