asp.net - Where do I put WHERE command on complex sql command -

database admin sent me sql command asp.net project. it's hard understand me.

command:

select to_char(firstdate, 'yyyymmdd') expr1, sum(single) singlefile, sum(sum) allfiles round(sum(singlesize) / (1024 * 1024 * 1024), 2) singlesize,             round(sum(sumsize)/(1024 * 1024 * 1024), 2) sumsize (select file, min(date) firstdate, 1 single, count(*) sum, max(size) singlesize, sum(size) sumsize             inetisle.xferlog             group file) derivedtbl_1 group char(firstdate,'yyyymmdd') order 1 

output this:

expr1       singlefile      sumfile         singlesize     sumsize 19.11.2014  123123          13423           12312423       23424132 

i need link expr1(date) calendar.

asp.net calendar control added this:

where ([expr1] = ?) 

where put on complex sql command?

i need select 1 day select on calendar.

select to_char(ilktarih, 'yyyymmdd') expr1, sum(toplam) toplamdosya,     round(sum(tekilboyut) / (1024 * 1024 * 1024), 2) tekilboyut,             round(sum(toplamboyut)/(1024 * 1024 * 1024), 2) toplamboyut (select dosya, min(tarih) ilktarih, 1 tekil, count(*) toplam, max(boyut) tekilboyut, sum(boyut) toplamboyut             inetisle.xferlog             date(tarih) = ?             group dosya) derivedtbl_1 group char(ilktarih,'yyyymmdd') order 1