Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon. Entire thread

SQL Code

Name: Anonymous 2008-02-06 23:13

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?

Name: Anonymous 2008-02-06 23:39

>>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.)
Newer Posts
Don't change these.
Name: Email:
Entire Thread Thread List
All trademarks and copyrights on this site are owned by their respective parties. All comments and posts are the responsibility of their own posters.
- Tinychan + 2ch Mode -