CommencerCommencer gratuitement

Combining WHERE and HAVING

You are interested in knowing which countries are bringing in the most revenue for eSymphony. More specifically, you want to list the countries with a total invoice amount of over $100. You have been informed that the data registered in Paris might be incorrect, so you decide to exclude Parisian invoices from your analysis.

To answer this question, you will need to use both WHERE and HAVING to filter the data.

Cet exercice fait partie du cours

Introduction to Oracle SQL

Afficher le cours

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

-- Select the BillingCountry and the total billing amount
SELECT ___, ___(___)
FROM Invoice
-- Group by billing country
___
-- Exclude groups with an invoice amount of more than 100
___
Modifier et exécuter le code