Check out example codes for "sql select data from last week". It will help you in understanding the concepts better.

Code Example 1

select id from tbname

where date between date_sub(now(),INTERVAL 1 WEEK) and now();

Code Example 2

select id from tbname
where date between date_sub(now(),INTERVAL 1 WEEK) and now();

Learn ReactJs, React Native from akashmittal.com