Hi, I am new to SQL training, I got a problem here. I have attached the data of two tables orders and order_items. where orders = o_id, c_id, o_date; order_items = o_id, it_id, it_qty; How can I solve the problem of getting total orders of last week when I run the query in this week(on any day). for example: I need the result of last week orders (i.e 8-feb-2-15 to 14-feb-2015) when i run the query today or tomorrow or any day of this week. I need a solution when I run the query on any day of this week, it should show me last weeks total orders, it should be dynamically. for example when I run the query next week of this month, it should display this week total orders and so on...., please help me with solution. thank you.