Consultas Sql Server
FROM Municipio AS M INNER JOIN
Cliente AS C ON M.idMunicipio = C.idMunicipio INNERJOIN
Factura AS F ON C.idCliente = F.idCliente
WHERE YEAR(F.fechaFactura) BETWEEN 2001 AND 2003
ORDER BY M.Municipio, C.codCliente
go
SELECT M.Municipio,C.codCliente, C.nombres, C.apellidos, F.fechaFactura, F.total
FROM Municipio AS M INNER JOIN
Cliente AS C ON M.idMunicipio = C.idMunicipio INNER JOIN
FacturaAS F ON C.idCliente = F.idCliente
WHERE YEAR(F.fechaFactura) NOT IN (2001, 2002)
ORDER BY M.Municipio, C.codCliente
go
SELECT M.Municipio, C.codCliente, C.nombres, C.apellidos,F.fechaFactura, F.total
FROM Municipio AS M INNER JOIN
Cliente AS C ON M.idMunicipio = C.idMunicipio INNER JOIN
Factura AS F ON C.idCliente = F.idClienteWHERE NOT (YEAR(F.fechaFactura) = 2001
OR YEAR(F.fechaFactura) = 2002)
ORDER BY M.Municipio, C.codCliente
go
SELECT M.Municipio, C.codCliente, C.nombres, C.apellidos, F.fechaFactura, F.totalFROM Municipio AS M INNER JOIN
Cliente AS C ON M.idMunicipio = C.idMunicipio INNER JOIN
Factura AS F ON C.idCliente = F.idCliente
WHEREYEAR(F.fechaFactura) NOT BETWEEN 2001 AND 2003
ORDER BY M.Municipio, C.codCliente
go
SELECT TOP 5 PERCENT M.Municipio, C.codCliente, C.nombres, C.apellidos, F.fechaFactura, F.total
FROMMunicipio AS M INNER JOIN
Cliente AS C ON M.idMunicipio = C.idMunicipio INNER JOIN
Factura AS F ON C.idCliente = F.idCliente
--WHERE nombres LIKE 'Ana%'--AND total > 2000
ORDER BY M.Municipio, C.codCliente
go
SELECT COUNT(*) FROM Cliente;
go
SELECT COUNT(*) AS [Total Registros]
, AVG( Total ) AS Promedio
, MAX( Total ) AS Maximo
,...
Regístrate para leer el documento completo.