--EXAMPLE -30 days select o_orderkey, o_orderstatus, o_orderdate, o_totalprice from orders where o_orderdate >= current_date -30