The following SQL will show customers and the orders they placed.

if we want to show shipping information of orders, then what table and columns are needed?

select $*$ from customers as c$,$ orders as o$,$ order$\_$items as oi

where c$.$customer$\_$id $=$ o$.$order$\_$customer$\_$id and o$.$order$\_$id $=$ oi$.$order$\_$item$\_$order$\_$id order by c$.$customer$\_$id;

a Shipping table having shipping$\_$date column to link to order table

a Shipping table having customer$\_$id column to link to customer table

a Shipping table having order$\_$id column to link to orders table

a Shipping table having shipping$\_$date column to link to customer table