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.

Easy?

person_id name

6 Tyson(E)

5 Meir(L)

4 Messi(D)

3 Alice(A)

2 Bob(P)

1 Alex(S)