Mycreation SELECT YEAR('2019-08-15 01:02:03')+10 Gg nw Employee Srinivas name Get max score and the fields in the max score row in MySQL 5.7 MySQL is added MySQL : calculate overlapping periods