SQL If statement

[triggerthat]

I want to basically find out if the count of something is more than 3, then apply a discount. I am creating a view.

Can anyone help?

 

[triggerthat]

Remove.

 

[triggerthat]

I don't want to change any items in the table just as yet.

Btw, in my middle statement, does that satify the 'inner join' clause?

Also, you said customer_ID = 20, I want to evaluate all customers.

 

[triggerthat]

There won't be a field that has a final value. The price is a composition of quantity and price. Both are in different tables. I wanted to satisfy if there is more than 2 or 3 orders, then show their final price with a discount.