Counting values
You suspect some customer records are incomplete. Rather than counting all records, you want to know how many customers have a value in the country field.
Count only customers that include country data to check data completeness.
Este ejercicio forma parte del curso
Introduction to SQL with AI
Instrucciones del ejercicio
- Describe what you want to see so the AI generates a query that counts only customers who have a value in the country field.
- Include a label for the result using the alias
country_count.
Ejercicio interactivo práctico
Prueba este ejercicio y completa el código de muestra.
SELECT COUNT(*) AS total_count
FROM customers;