… customer_id, customer_name, sale_when; $ php convert.php demo < sales.sql CALL flexviews.create('demo', ..._name'); CALL flexviews.add_expr(@mvid,'GROUP','DATE_FORMAT(order_date,”%Y%m”)’,'sale_when’); CALL flexviews… `mview$pk` which is an auto_increment BIGINT surrogate key for the table. For complete…