Loading...
Classify Services by Name
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- mid
Problem
The platform catalog needs a service taxonomy. Classify each service: 'api_service' if the name contains 'api', 'cache_service' if it contains 'cache' or 'redis', 'database' if it contains 'db' or 'postgres', and 'other' for everything else. Each service should appear only once. Show the service name and its category, limited to the first 100 results.
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.