Query in MySQL -- 2

Job ID: 34665719

Budget: $10 – $30 USD

I need help to create an SQL query in MySQL or programming logic in PHP to know if a store is open or closed. Example a store works from 5:00 p.m. to 2:00 a.m. (24-hour format). That is, it opens every day at 5:00 p.m. and closes at 2:00 a.m. (it changes day). Now if I record the example hours of sale that that store is closed.

I share the table to run the SQL query.
Related categories: PHP SQL MySQL Database Administration