Write a statement that displays these fields customer 's first name customer 's last name order id order date of orders placed Use the default JOIN type, use table aliases of C for customers and O for orders, and use the ON keyword when joining The fields should be displayed in the order listed abo...

The Answer is in the image, click to view ...

Write a statement that displays these fields: customer's first name customer's last name order id order date

Fantastic news! We've Found the answer you've been seeking!

Question:

Write a statement that displays these fields:

customer's first name
customer's last name
order id
order date of orders placed

Use the default JOIN type, use table aliases of C for customers and O for orders, and use the ON keyword when joining. The fields should be displayed in the order listed above.

Notes:

This statement requires joining tables together so I recommend you review the document provided titled 'Notes on database om'.
Copy/Paste your answer from your Workbench into the textbox below
Remove any "extra" spaces between each keyword