I had a big misunderstanding to the "BETWEEN" operator respect to datetime columns in MySQL.I had thought that "BETWEEN" does not contain the value of end when the date value is used respect to datetime columns like this. SELECT * FROM sam…