Modify the previous question to display all customers even if they don't have an order. Order the results by the order ID$.$

List the customers' names, country, order ID$,$ and order dates.

select customername,

$,$orderid, orderdate

from customers

orders

$($

$.$customerid$=$

$.$customerid$)$

where

$=\text{'}$

$\text{'}$