23 solved exercises

Function

Solutions and examples for MySQL.

Showing 1–20 of 23 problems

  1. 01Show each employees employee_id, first_name and his salary in - 10 thousands 5 hundreds and 12 taka only format
  2. 02For each jobs, show the job_id, job_title and how much greater the max_salary then min_salary in percentage
  3. 03Show each employees employee_id, and yearly total salary with commission he receives
  4. 04Show each employees email, hire_date in January 4th, 1987 format
  5. 05Show each employees email, hire_date in Jan 1987, 04 format
  6. 06Show each employees email, hire_date in 1st Aug, 87 05:10 PM format
  7. 07Show each employees email, hire_date in 15 Jan, 2019 Tuesday 14:10 format
  8. 08Show those employees first_name, email, phone_number, address who is hired after the date 05 May, 1987 00:00 AM
  9. 09Show those employees first_name, email, phone_number, address details who is hired before the date 1st June 1987 12:01 PM
  10. 10Show each employees employee_id and his total current experience(upto present date) in number of years format
  11. 11Show each employees employee_id, email and his total current experience in 10 years, 6 months and 15 days format
  12. 12Show those employee_id s from the job_history table whose total experience is greater than 5 years
  13. 13For each job_history, show how many days an employee have served during his last month of retirement
  14. 14Show how many days an employee have served during his first month of joining
  15. 15Show those employees details who have been hired in the leap day(19th Feb) of any leap year
  16. 16Show those employees details whose hiring month is either 2 or 4 or 6 or 8
  17. 17Show each employees first_name, department_id, manager_id and his modified join_date that is one week before the his real join_date
  18. 18 From the employees table, show each employees employee_id, join_date and estimated retirement date that is 30 years after his join_date
  19. 19Show each employees short name that is first 3 letters from the first name followed by an underscore and then followed by the first 3 letters from last_name
  20. 20Show those employees names that is a palindrome