tiene campos vacios a los que complete con 'PENDIENTE', necesito una consulta para totalizar los pendientes de cada columna el cual logre con esto
SELECT
(
SELECT COUNT(*)
FROM "GANADERIA ABRIL 2018"
WHERE
Direccion = 'PENDIENTE'
) as Direccion,
(
SELECT COUNT(*)
FROM "GANADERIA ABRIL 2018"
WHERE
Telefono = 'PENDIENTE'
) as Telefono,
(
SELECT COUNT(*)
FROM "GANADERIA ABRIL 2018"
WHERE
tipoCliente = 'PENDIENTE'
) as tipoCliente,
(
SELECT COUNT(*)
FROM "GANADERIA ABRIL 2018"
WHERE
NombreContacto = 'PENDIENTE'
) as NombreContacto,
(
SELECT COUNT(*)
FROM "GANADERIA ABRIL 2018"
WHERE
numeroCelular = 'PENDIENTE'
) as numeroCelular,
(
SELECT COUNT(*)
FROM "GANADERIA ABRIL 2018"
WHERE
correoElectronico = 'PENDIENTE'
) as correoElectronico
UNION
SELECT
COUNT(Direccion) as Direccion,
COUNT(Telefono) as Telefono,
COUNT(tipoCliente) as tipoCliente,
COUNT(NombreContacto) as NombreContacto,
COUNT(numeroCelular) as numeroCelular,
COUNT(correoElectronico) as correoElectronico
FROM "GANADERIA ABRIL 2018"
UNION
SELECT
(
SELECT COUNT(Direccion)
FROM "GANADERIA ABRIL 2018"
WHERE
Direccion = 'PENDIENTE'
)/ count(*) * 100 as Direccion,
(
SELECT COUNT(Telefono)
FROM "GANADERIA ABRIL 2018"
WHERE
Telefono = 'PENDIENTE'
)/ count(*) * 100 as Telefono,
(
SELECT COUNT(tipoCliente)
FROM "GANADERIA ABRIL 2018"
WHERE
tipoCliente = 'PENDIENTE'
)/ count(*) * 100 as tipoCliente,
(
SELECT COUNT(NombreContacto)
FROM "GANADERIA ABRIL 2018"
WHERE
NombreContacto = 'PENDIENTE'
)/ count(*) * 100 as NombreContacto,
(
SELECT COUNT(numeroCelular)
FROM "GANADERIA ABRIL 2018"
WHERE
numeroCelular = 'PENDIENTE'
)/ count(*) * 100 as numeroCelular,
(
SELECT COUNT(correoElectronico)
FROM "GANADERIA ABRIL 2018"
WHERE
correoElectronico = 'PENDIENTE'
)/ count(*) * 100 as correoElectronico
FROM "GANADERIA ABRIL 2018"