SELECT c$.$customer$\_$id$,$ o$.$order$\_$id$,$ o$.$order$\_$date, p$.$product$\_$name FROM customer c$,$ curr$\_$order o$,$ product p WHEREcustomer.customer$\_$id $=$ curr$\_$order.customer$\_$id AND o$.$product$\_$id $=$ p$.$product$\_$id ORDER BY o$.$order$\_$amount;This statement fails when executed. Which change will correct the problem?Remove the table aliases from the WHERE clause.Use the table aliases instead of the table names in the WHERE clause$\mathrm{.}1$ Use the table name in the ORDER BY clause.Include the ORDER AMOUNT column in the SELECT list