From server_logs, create a formatted log identifier by zero-padding the log_id to 6 digits with the

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

Domain

SQL

Difficulty

medium

Problem

From server_logs, create a formatted log identifier by zero-padding the log_id to 6 digits with the prefix 'LOG-' using FORMAT. Return log_id, server_name, and the formatted identifier. Order by log_id and limit to 5 rows.

Practice This Problem

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