Which state has the most customers?
select state from customers group by state order by count ( * ) limit 1
How many customers have the customer type code "Good Credit Rating"?
select count ( customer_id ) from customers where customer_type_code = "Good credit Rating"
What are the states of all customers who who have the customer type code Good Credit Rating?
select state from customers where customer_type_code = "Good credit Rating"
What are the customer ids of all customers who who have the customer type code Good Credit Rating?
select customer_id from customers where customer_type_code = "Good credit Rating"