Mysql – Please explain the execution of this simple SQL query
DDL & DMLs for creating this table: Create table If Not Exists Delivery (delivery_id int, customer_id int, order_date date, customer_pref_delivery_date date); Truncate table Delivery; insert into Delivery (delivery_id, customer_id, order_date, customer_pref_delivery_date) values ('1', '1', '2019-08-01', '2019-08-02'); insert into Delivery (delivery_id,…