Separar y sumar datos de una misma columna

[GeoAvila]

SELECT FACTURA, MOVIL,
(SELECT SUM(valor + sobrecargo)
FROM trafico
WHERE factura = a.factura AND movil = a.movil),
(SELECT SUM(valor + sobrecargo)
FROM trafico
WHERE factura = a.factura AND movil = a.movil AND SERVICIO = 'BAM' AND) AS BAM,
(SELECT SUM(valor + sobrecargo)
FROM trafico
WHERE factura = a.factura AND movil = a.movil AND SERVICIO = 'MMS' AND) AS MMS,
(SELECT SUM(valor + sobrecargo)
FROM trafico
WHERE factura = a.factura AND movil = a.movil AND SERVICIO = 'RPV' AND) AS RPV,
(SELECT SUM(valor + sobrecargo)
FROM trafico
WHERE factura = a.factura AND movil = a.movil AND SERVICIO = 'SME' AND) AS SME,
(SELECT SUM(valor + sobrecargo)
FROM trafico
WHERE factura = a.factura AND movil = a.movil AND SERVICIO = 'SMR' AND) AS SMR,
(SELECT SUM(valor + sobrecargo)
FROM trafico
WHERE factura = a.factura AND movil = a.movil AND SERVICIO = 'TEL' AND) AS TEL,
(SELECT SUM(valor + sobrecargo)
FROM trafico
WHERE factura = a.factura AND movil = a.movil AND SERVICIO = 'TLL' AND) AS TLL
FROM TRAFICO a
WHERE (FACTURA = '16209216')
GROUP BY FACTURA, MOVIL

te señale esos "and" porque están demás depues de servicio = 'XX' no puede ir un And si no haces otra sentencia. quita los AND despues del servicio = 'XX'


nos vemos.