exam-select-latest-by-team_name.sql 160 B

12345
  1. select id, begin_time, end_time, score_report_path, team_name
  2. from exam
  3. where team_name = ?
  4. and DATE (begin_time) = CURDATE()
  5. order by begin_time desc limit 1