Consider the following tables in a database: 1. Customer_T…
Consider the following tables in a database: 1. Customer_T CustomerID CustomerName City Country 1 John Smith New York USA 2 Jane Doe London UK 3 Emily Davis Toronto Canada 2. Order_T OrderID CustomerID OrderDate TotalAmount 101 1 2023-01-15 150.00 102 2 2023-02-20 200.00 103 1 2023-03-05 300.00 Task: Write an SQL query to retrieve the CustomerName, OrderID, and TotalAmount for all orders where the TotalAmount is greater than 100. Sort the results by TotalAmount in descending order.
Read Details