How to write a request correctly? Is an investment required?

Question

MySQL

it is necessary to select the data for today and for yesterday from the table for each id. I understand how to do this with two requests, but how can I merge it into one? Tell me please.

Answer 1

Put the condition through OR.

Answer 2

Something like this

SELECT 
    ... 
WHERE 
    DATE(`date`) >= DATE(DATE_SUB(NOW(), INTERVAL 1 DAY)) 
GROUP BY DATE(`date`)