SQL Code

I am having trouble trying to write some SQL code with discounting. Lets say customers who are part of a program gets 15% discount off books.

How should I write that in SQL Code?

>>1
Well, judging from THE COMPLETE FUCKING LACK OF INFORMATION IN YOUR POST, subtract 15% from the total price if the customer is part of a program.

>>1
First you'll have to go back to India, Rasheed. Then I'm going to have to ask you and your fifty wives to get right out of the IT industry and go wash some clothes in your nasty dirty river.

I fucking hate Indians.

Also, >>1, even if you aren't a damn Indian, you're as dumb as one, so it doesn't really matter.

FUKKEN SAGED

>>2

OK HERE YOU GO!

Customers that are part of a special program get a 15% discount off regular book prices. To determine the discounted prices, list the book code, title, and discounted price of every book. (The calculated column should calculate 85% of the current price, which is 100% less a 15% discount.)

>>4
SELECT 0.85 * book_price FROM MY_FUCKING_TABLE WHERE I_AM_A_COMPLETE_FUCKING_IDIOT

>>4
Post your schema

>>3
Hope you're enjoying your unemployment, while Abdul works 10x better than you ever did at half the cost.

>>1
You will need a variable and a constant.