SELECT medicalSn,pName

FROM tb_patient

WHERE medicalDateTime >= '2025-04-16 00:00:00'

  AND medicalDateTime < '2025-04-17 00:00:00'

  AND `status` = 1

ORDER BY medicalSn desc