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.
Este exercício faz parte do curso
Introduction to SQL with AI
Instruções do exercício
- 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.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
SELECT COUNT(country) AS country_count
FROM customers;