Hi,

I need to show Quantity sold for three consecutive days (yesterday, today, tomorrow).
So, date should be the first column and Quantity being second.

Desired Output
--------------
Date Qty
.... ...
8/4/2018 10
9/4/2018 20
10/4/2018 30

Need to use SysDate for getting the date. I tried as below and able to get the quantity sold for single date.

select sysdate, count(Order_id) as Qty from Orders;

Please note that I can't use Union in my scenario.

Kindly let me know if this can be achieved in any way.

Thanks in advance.

SQL> with three_rows as
  2   ( select trunc(sysdate)-2+rownum dte from dual connect by level <= 3 )
  3  select * from three_rows;

DTE
---------
09-APR-18
10-APR-18
11-APR-18