I want to know the payment methods available
select distinct payment_method from customers
How many customers use credit credit card as a means of payment?
select count ( * ) from customers where payment_method = "Credit Card"
What about Cash?
select count ( * ) from customers where payment_method = "Cash"
And Cheque?
select count ( * ) from customers where payment_method = "Cheque"