Evaluatie van modules

Verzonden

Afgeleverd

NUL

SELECT City, COUNT(*) AS AantalKlanten FROM Sales.Customer;

SELECT Stad, COUNT(*) AS KlantAantal FROM Verkoop.Klant GROUP BY Stad;

SELECT City, COUNT(*) AS KlantAantal FROM Sales.Customer ORDER BY City;

SELECT Category, AVG(Price) FROM Store.Product WHERE AVG(Price) > 10,00;

SELECT Category, AVG(Price) FROM Store.Product GROUP BY Category WHERE AVG(Price) > 10,00;

SELECT Category, AVG(Price) FROM Store.Product GROUP BY Category HAVING AVG(Price) > 10,00;