A:
SELECT customer_id,ord_date,MAX(purch_amt) FROM orders GROUP BY customer_id,ord_date;
find the highest purchase amount ordered by the each customer on a particular date with their ID, order date and highest purchase amount.
A:
SELECT customer_id,ord_date,MAX(purch_amt) FROM orders GROUP BY customer_id,ord_date;
find the highest purchase amount ordered by the each customer on a particular date with their ID, order date and highest purchase amount.