Weekly post output?

Question

MySQL

How can I add the output of viewed posts for a week with such a request?
Where Views - Views
($sqlConnect, "SELECT `id` FROM {$type_table} WHERE `postType` = 'post' ORDER BY `views` DESC LIMIT 3");

Answer 1

SELECT `id` FROM {$type_table} WHERE `postType` = 'post' AND date_publish BETWEEN date_start AND date_end ORDER BY `views` DESC LIMIT 3

date_publish - date of publication
date_start - start of week
date_end - end of week