Untitled

SELECT '20070530' as datef, 'All Net', COUNT(DISTINCT CASE WHEN qt_mo
c>0 OR qt_mtc>0 or qt_cfw_no_vms > 0 THEN servedmsisdn END), COUNT(DISTINCT CASE WHEN qt_mocSMS>0 OR qt_mtcSMS>0 THEN served
msisdn END), COUNT(DISTINCT CASE WHEN qt_moc>0 OR qt_mtc>0 OR qt_cfw_no_vms > 0 OR qt_mocSMS>0 OR qt_mtcSMS>0 THEN servedmsi
sdn END) FROM top_moc as t WHERE date between '20070501' and '20070530'

*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: t
         type: ALL
possible_keys: ix_top_moc_date,ix_top_moc_datemsisdn
          key: NULL
      key_len: NULL
          ref: NULL
         rows: 155972491
        Extra: Using where
1 row in set (0.38 sec)