I'm looking for a stored procedure to calculate Discounts for publishers by passing their pubID.
Each discounts vary per publishers.
All of A Publishers will get 10% discount this month for all thrie published books
All of B Publishers will get 20% discounts this month for all thrie published books
All of C Publishers will get 30% discounts on all their books this month.
How to build the stored procedure.