Welcome to Subscribe On Youtube
Formatted question description: https://leetcode.ca/all/2504.html
2504. Concatenate the Name and the Profession
Description
Table: Person
+-------------+---------+ | Column Name | Type | +-------------+---------+ | person_id | int | | name | varchar | | profession | ENUM | +-------------+---------+ person_id is the primary key for this table. Each row in this table contains a person's ID, name, and profession. The profession column in an enum of the type ('Doctor', 'Singer', 'Actor', 'Player', 'Engineer', or 'Lawyer')
Write an SQL query to report each person's name followed by the first letter of their profession enclosed in parentheses.
Return the result table ordered by person_id
in descending order.
The query result format is shown in the following example.
Example 1:
Input: Person table: +-----------+-------+------------+ | person_id | name | profession | +-----------+-------+------------+ | 1 | Alex | Singer | | 3 | Alice | Actor | | 2 | Bob | Player | | 4 | Messi | Doctor | | 6 | Tyson | Engineer | | 5 | Meir | Lawyer | +-----------+-------+------------+ Output: +-----------+----------+ | person_id | name | +-----------+----------+ | 6 | Tyson(E) | | 5 | Meir(L) | | 4 | Messi(D) | | 3 | Alice(A) | | 2 | Bob(P) | | 1 | Alex(S) | +-----------+----------+ Explanation: Note that there should not be any white space between the name and the first letter of the profession.
Solutions
-
# Write your MySQL query statement below SELECT person_id, CONCAT(name, "(", substring(profession, 1, 1), ")") AS name FROM Person ORDER BY person_id DESC;