inblog logo
|
silver
    SQL문제풀기

    [SQL문제풀기] Fix Names in a Table

    silver's avatar
    silver
    Nov 19, 2025
    [SQL문제풀기] Fix Names in a Table
    Contents
    문제MySQL

    문제

    Fix Names in a Table - LeetCode
    Can you solve this real interview question? Fix Names in a Table - Table: Users +----------------+---------+ | Column Name | Type | +----------------+---------+ | user_id | int | | name | varchar | +----------------+---------+ user_id is the primary key (column with unique values) for this table. This table contains the ID and the name of the user. The name consists of only lowercase and uppercase characters.   Write a solution to fix the names so that only the first character is uppercase and the rest are lowercase. Return the result table ordered by user_id. The result format is in the following example.   Example 1: Input: Users table: +---------+-------+ | user_id | name | +---------+-------+ | 1 | aLice | | 2 | bOB | +---------+-------+ Output: +---------+-------+ | user_id | name | +---------+-------+ | 1 | Alice | | 2 | Bob | +---------+-------+
    Fix Names in a Table - LeetCode
    https://leetcode.com/problems/fix-names-in-a-table/description/?envType=study-plan-v2&envId=top-sql-50
    Fix Names in a Table - LeetCode

    MySQL

    내가 작성한 정답

    select user_id ,concat(upper(left(name,1)),lower(substring(name,2))) name from Users order by 1;
    Share article

    silver

    RSS·Powered by Inblog