Question

databases

Write a SQL query that shows the OrderID, OrderDate, CustomerID, TotalAmount, ProductID, Quantity for orders with a TotalAmount of 1000 and above. The results need to be sorted by TotalAmount in ascending order.

Answer 1

Select Query for getting all the orders:

select * from Orders;

Select Query for getting all the orders with totalamount>=1000

select * from Orders WHERE totalamount>=1000;

Select Query for getting all the orders with totalamount>=1000 in ascending order

select * from Orders WHERE totalamount>=1000 ORDER BY totalamount ASC;

Screenshots for additional help:

for all orders

for order whose totalAmount>=1000

I HOPE THIS WILL HELP. THANKS.