Counting unique values
PoweredHomes is expanding internationally and needs to understand their current global reach. In your final exploration of the customers table you want to generate a summary of the countries you're already working with.
Use the AI assistant to generate this summary.
Diese Übung ist Teil des Kurses
Introduction to SQL with AI
Anleitung zur Übung
- Write a prompt that counts the number of unique country values in the customers table.
- Make sure the result is labeled using the alias
unique_countries.
Interaktive Übung
Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.
SELECT COUNT(country) AS country_count
FROM customers;