please answer from 5 to 9 questions they are mysql database

please answer from 5 to 9 questions.
they are mysql database coding questions.

4. Based on the information entered info the table, use the command below to display and all employee table EMPLOYEE s, Make a change to the table structure and change a column name and the datatype definitinn in the Employee Payroll Database Application table created above. You choose which field you would like to EMPLOYEE 6. Create a query to view (at least 3 fields) one of the employees\' formation loaded into the Employee Payroll Database Application table created above. You choose which three fields you would like to retrieve from the table. Base your query on a 7. a query to view the employees\' names loaded into the Employee PayToll Database Application table created above and display the names in descending order. Use the commands to combine the first and last name and display as a full name in the query. EMPLOYEE s. save all nformation in the table 9. Write to determine how many records are loaded into the table and change the heading from count a query to number. 4 INSERT CHAR 2, DATE 8- SELECT ABLE 7. VALUES KE AND COUNT 8. ADD FROM ALTER NOT NU 25. AFTER DISTINCT 23. COMM 21, ORDER BY 29 DESC 30, CONCAT 28, COUNT 26 SHOW 27, CHANGE

Solution

5. ALTER TABLE EMPLOYEE

RENAME COLUMN ADD TO ADDRESS

6. SELECT Fname, Lname, ADDRESS FROM EMPLOYEE WHERE 1

7. SELECT Name FROM EMPLOYEE ORDERBY, DESC NAME

8. COMMIT;

9. SELECT COUNT(*) AS number FROM EMPLOYEE.

if you like this answer, please give a thumbs up and if you have some doubt just ask in the comment section below. I will try to help. Cheers