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