This is from Murach's MySQL 2nd Edititon (pages 146-147)

4. Write a SELECT statement that returns these five columns: vendor name invoice date invoice number ln_sequence The vendor name column from the Vendors table The invoice date column from the Invoices table The invoice number column from the Invoices table The invoice_sequence column from the Invoice_Line_Items table The line item amount column from the Invoice_Line_Items table li_ amount Use aliases for the tables. This should return 118 rows, Sort the final result set by vendor_name, invoice_date, invoice_number, and nvoice sequence