Solutions:
Check these solutions from our community and artificial intelligence:
The solution above is optimal because it uses the NOW() function to get the current time and subtracts 1 day from it.
This is optimal because it will always return the correct results.