Q.Write an SQL query to display the OrderNo and Amount of all orders above 5000 that belong to the customer whose CustID is 3, from the Orders table.

This needs a WHERE clause that combines two conditions with AND — a value greater than 5000 and a particular customer. …

This query needs two conditions at once, so we combine them in the WHERE clause with the AND operator (both conditions must be true for a row to be kept):

1. Amount above 5000: Amount > 5000 — the > operator means 'greater than', and the number is written without quotes.
2. Belongs to customer 3: CustID = 3 — again a number, written plainly.

We select only the OrderNo and Amount columns. The complete query is:

SELECT OrderNo, Amount FROM Orders
WHERE Amount > 5000 AND CustID = 3;
``` …

To find orders that are either large OR belong to customer 3 (a wider result), replace AND with OR: `SELECT OrderNo, Amo …

Use AND when both conditions must hold together; OR would wrongly widen the result. Numbers such as 5000 and 3 …