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.
This exercise is part of the course
Introduction to SQL Querying with AI
Exercise instructions
- 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.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT COUNT(*) AS total_count
FROM customers;