Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

Please compile your questions in word file as below

Question 1 : Find the average salary of all staff

select concat('$',round(avg(salary),2)) as 'avrage salary' from employee;

Question 2: Find the age of the all employees

select name, timestampdiff(year, dob,curdate()) as employeeAge from employee;

Question 3: Find the total count of staff born in each month of the year

Find the total count of staff born in each month of the year

select monthname(dob) as monthName, count(*) as tot from employee

group by monthName;