in_date     item_code
---------   ---------
2015/11/25  item1
2015/11/25  item2
2015/12/10  item1
2015/12/10  item1
2015/12/10  item2
2016/01/01  item1

Date          Item1     Item2
----------    -----     -----
2015/11/25    1         1
2015/12/10    2         1
2016/01/01    1         0

Select
  in_date,
  Sum (case when item_code = item1 then 1 else 0 end) item1,
  Sum (case when item_code = item2 then 1 else 0 end) item2
From tbl
Group by in_date