How to write the syntax for this question

Question

Products that bring < $1.00 profit per purchase need to be deleted?

Answer 1

I am assuming you are trying to delete tuples and your table contains the profit per purchase attribute:
DELETE FROM [tableName]
WHERE profit < 1.00

Answer 2

I guess you can take the (salePrice - originalPrice) < 1.00 since it is per purchase, so it is more of like individual instead of counting it weekly, monthly, or yearly as a group

Answer 3

no problem

Answer 4

My table doesnt have per purchase. It has the price, weeklysale, montlysale and yearlysale

Answer 5

Got you thanks