1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| SELECT Sum(CASE WHEN vdn in ('1244','1247','1248','1249','1250','1251','1285','1290') THEN busycalls ELSE 0 END) as busycalls,
Sum(CASE WHEN vdn in ('1244','1247','1248','1249','1250','1251','1285','1290') THEN disccalls ELSE 0 END) as discalls,
Sum(CASE WHEN vdn in ('1244','1247','1248','1249','1250','1251','1285','1290') THEN abncalls ELSE 0 END) as abncalls,
Sum(CASE WHEN vdn in ('1244','1247','1248','1249','1250','1251','1285','1290') THEN incalls ELSE 0 END) as incalls,
Sum(CASE WHEN vdn in ('1308','1312','1321','1325','1327','1329','1310','1331') THEN busycalls ELSE 0 END) as busycalls2,
Sum(CASE WHEN vdn in ('1308','1312','1321','1325','1327','1329','1310','1331') THEN disccalls ELSE 0 END) as discalls2,
Sum(CASE WHEN vdn in ('1308','1312','1321','1325','1327','1329','1310','1331') THEN abncalls ELSE 0 END) as abncalls2,
Sum(CASE WHEN vdn in ('1308','1312','1321','1325','1327','1329','1310','1331') THEN incalls ELSE 0 END) as incalls2,
Sum(busycalls) as busycallstotal,
Sum(disccalls) as discallstotal,
Sum(abncalls) as abncallstotal,
Sum(incalls) as incallstotal
FROM dvdn
WHERE row_date = '28/11/2005'
AND vdn in ('1244','1247','1248','1249','1250','1251','1285','1290',
'1308','1312','1321','1325','1327','1329','1310','1331') |
Partager