Hello. Can you give me the state in the US with most invoices?
select billing_state from invoices where billing_country = "USA" group by billing_state order by count ( * ) desc limit 1
How about postal codes for these invoices?
select distinct billing_postal_code from invoices where billing_state = ( select billing_state from invoices where billing_country = "USA" group by billing_state order by count ( * ) desc limit 1 )
Yes, date of invoice please
select distinct invoice_date from invoices where billing_state = ( select billing_state from invoices where billing_country = "USA" group by billing_state order by count ( * ) desc limit 1 )