I'm a new SQL programmer, so sorry if i'm doing a basic question.
I've made a DB for a fictional store(for learning purposes), now i want to now how many products the store fixed on the last 7 days.
So i did a SELECT COUNT(products.Id_Fixes) FROM Products, Store WHERE products.id_products=store.id_products AND store.entry_date... /*and now i want SQL to grab present date and substract 7 to all entry_dates so i know how many products where fixed on the last 7 days.
Can someone help me with this please?