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