Just gone back to school. Doing computer stuff for the first time and finding it a little difficult.
Here's what I need to do:
List all OrderIDs for orders whose totalAmount is between €250 and €500.
Here's what I've done:
SELECT orderid
FROM order
WHERE totalamount IN(SELECT totalamount
FROM orderid
WHERE totalamountBETWEEN 250.00 AND 500.00);
Am I right?
Here's what I need to do:
List all OrderIDs for orders whose totalAmount is between €250 and €500.
Here's what I've done:
SELECT orderid
FROM order
WHERE totalamount IN(SELECT totalamount
FROM orderid
WHERE totalamountBETWEEN 250.00 AND 500.00);
Am I right?