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 ejercicio forma parte del curso
Introduction to SQL with AI
Instrucciones del ejercicio
- 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.
Ejercicio interactivo práctico
Prueba este ejercicio y completa el código de muestra.
SELECT COUNT(country) AS country_count
FROM customers;