Advanced grouping
You are interested in knowing how much money is coming in from cities in the USA and Canada. This information can be found in the Total column of the Invoice table.
To solve this problem, you will need to combine multiple statements that you've seen earlier in this chapter, such as aggregate functions, WHERE, GROUP BY, and ORDER BY.
Diese Übung ist Teil des Kurses
Introduction to Oracle SQL
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- Select the BillingCountry, BillingCity
___ ___, ___
FROM Invoice
-- Filter on BillingCountry
___ BillingCountry ___ (___, ___)