I need the first name and last name please
select t1.first_name, t1.last_name from customers as t1 join invoices as t2 on t2.customer_id = t1.id order by t2.invoice_date desc limit 5
How about their cities and states?
select t1.first_name, t1.last_name, t1.city, t1.state from customers as t1 join invoices as t2 on t2.customer_id = t1.id order by t2.invoice_date desc limit 5
Can you also give me the countries?
select t1.first_name, t1.last_name, t1.city, t1.state, t1.country from customers as t1 join invoices as t2 on t2.customer_id = t1.id order by t2.invoice_date desc limit 5
How about their e-mail addresses?
select t1.email from customers as t1 join invoices as t2 on t2.customer_id = t1.id order by t2.invoice_date desc limit 5