| Line 74... |
Line 74... |
| 74 |
--and tt.rn_execution_date >= '20111001' AND tt.rn_execution_date < '20111101'
|
74 |
--and tt.rn_execution_date >= '20111001' AND tt.rn_execution_date < '20111101'
|
| 75 |
and tt.rn_tester_name IN ('aphoon','amatveev','aserrain','clee','ekilic','fpatel','lguntur',
|
75 |
and tt.rn_tester_name IN ('aphoon','amatveev','aserrain','clee','ekilic','fpatel','lguntur',
|
| 76 |
'ggrieve','hbatna','idzukleski','jgodfrey','jkoh','kmuruges','knguyen',
|
76 |
'ggrieve','hbatna','idzukleski','jgodfrey','jkoh','kmuruges','knguyen',
|
| 77 |
'lmiao','mthangav','nkerr','ozaidenv','rthumma','rohearn','sip','kmaesen2',
|
77 |
'lmiao','mthangav','nkerr','ozaidenv','rthumma','rohearn','sip','kmaesen2',
|
| 78 |
'slibao','stan','tkumar','wloo','ywehalle','sradhakr','bboey','silyas',
|
78 |
'slibao','stan','tkumar','wloo','ywehalle','sradhakr','bboey','silyas',
|
| 79 |
'wwong','mchua','dmonahan','awehalle')
|
79 |
'wwong','mchua','dmonahan','awehalle','ahulatt','aphoon2','clee1','ahulatt1')
|
| 80 |
) dd
|
80 |
) dd
|
| 81 |
GROUP BY dd.test_month,dd.project
|
81 |
GROUP BY dd.test_month,dd.project
|
| 82 |
ORDER BY dd.test_month,dd.project;
|
82 |
ORDER BY dd.test_month,dd.project;
|
| 83 |
|
83 |
|