Experiment 16-14 in TestDB: Find customers for each customer (including customers without orders)

TestDB is a product sales database, in TestDB: Find the customer number, name, order date, order amount for each customer (including customers without orders), where the order date format is YYYY-MM-DD, sorted by customer number, and the same customer then sorts the output in descending order amount.

Select  customer.cust_id,cust_name,convert (varchar), order_date,121) as Order_date,tot_amtfrom  customer Left OUTER JOIN  

　　

Experiment 16-14 in TestDB: Find customers for each customer (including customers without orders)