Crowdly
Add to Chrome
- Campus Central - BASES DE DATOS I Vespertina [02] [1er. Semestre 2026] 360098
Looking for - Campus Central - BASES DE DATOS I Vespertina [02] [1er. Semestre 2026] 360098 test answers and solutions? Browse our comprehensive collection of verified answers for - Campus Central - BASES DE DATOS I Vespertina [02] [1er. Semestre 2026] 360098 at moodle26.url.edu.gt.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
SELECT TOP 5 ProductID, COUNT(*) AS VecesEnPedidos
FROM Sales.SalesOrderDetail
GROUP BY ProductID
ORDER BY COUNT(*) DESC;¿Qué devuelve esta consulta?
SELECT c.CustomerID, MAX(h.TotalDue) AS MaxCompra
FROM Sales.Customer c
LEFT JOIN Sales.SalesOrderHeader h
ON c.CustomerID = h.CustomerID
GROUP BY c.CustomerID
HAVING MAX(h.TotalDue) > 10000;¿Qué ocurre con los clientes que no tienen ningún pedido?
SELECT *
FROM Sales.SalesOrderHeader
WHERE TotalDue > 1000 AND TotalDue < 5000;
Afirmación: Esta consulta es equivalente a usar WHERE TotalDue BETWEEN 1000 AND 5000, ya que ambas devuelven el mismo conjunto de resultados.SELECT ProductID, SUM(OrderQty) AS TotalUnidades
FROM Sales.SalesOrderDetail
GROUP BY ProductID
HAVING SUM(OrderQty) > 500
ORDER BY TotalUnidades DESC;¿Qué devuelve esta consulta?