Select two columns with different where clause : I want to select two columns, for the example one name x and the other one is y
for to get x data I need to write in the where clause IsTure='no' and count the the id by grouping by date.

and for y in need to count the id by different where clause and group by date also. 
and the date field is different for x and y
It should like this : 

Id  Date x  y 



How can I implement this kind of query ?
Thanks