how many customers are presented on the table
select count ( * ) from customers
show all the customers name
select customer_name from customers
what is the customer number of Kayley
select customer_number from customers where customer_name = "Kayley"
what is the order status code of Sterling
select t2.order_status_code from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id where t1.customer_name = "Sterling"
show the name of the customer who has the most orders
select t1.customer_name from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id group by t1.customer_id order by count ( * ) desc limit 1