MySQL Query error using CONCAT and Group By

I need to generate the following two result sets:

Query an alphabetically ordered list of all names in OCCUPATIONS, immediately followed by the first letter of each profession as a parenthetical (i.e.: enclosed in parentheses).
For example: AnActorName(A), ADoctorName(D), AProfessorName(P), and ASingerName(S).

Query the number of occurrences of each occupation in OCCUPATIONS. Sort the occurrences in ascending order, and output them in the following format:

There are total [occupation_count] [occupation]s.

Table Name: Occupations

Total Columns: Two = ‘Name’ and ‘Occupation’,
demo table is shown below:

Table: Occupations

Sample Output:

Ashely(P)
Christeen(P)
Jane(A)
Jenny(D)
Julia(A)
Ketty(P)
Maria(A)
Meera(S)
Priya(S)
Samantha(D)
There are total 2 doctors.
There are total 2 singers.
There are total 3 actors.
There are total 3 professors.

My Approach

SELECT CONCAT(NAME,' ', '(',UPPER(SUBSTR(occupation,1,1)),')') AS occupation 
FROM OCCUPATIONS 
ORDER BY NAME;

SELECT CONCAT('There are a total of',' ',COUNT(occupation),' ', LOWER(occupation),'s','.') AS OCCUPATION_COUNT 
FROM OCCUPATIONS 
GROUP BY OCCUPATION 
ORDER BY COUNT(OCCUPATION) ASC;

I don’t know why it’s error