Leetcode Problem 2504. Concatenate the Name and the Profession

2504. Concatenate the Name and the Profession

Leetcode Solutions

Concatenating Profession Initial with Name

Select the person_id column as is.
Use the CONCAT function to combine the name column with the first letter of the profession column, which is obtained using the LEFT function, and enclose this letter in parentheses.
Alias the concatenated string as name.
Order the results by person_id in descending order to meet the output requirement.


erDiagram
    Person {
        int person_id
        varchar name
        ENUM profession
    }

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Loading...

Suggested Answer

Answer

Full Screen

Copy Answer Code

Loading...