Orders by Customers
select c.company, o.orderno, cast(saledate as date) saledate, cast(shipdate as date) shipdate,
paymentmethod, itemstotal, amountpaid, e.lastname
from customer c join orders o on o.custno=c.custno
join employee e on e.empno=o.empno
order by 1