t-sql

TSQL Challenge 11: Calculating the lowest price of an item by applying discount coupons
TSQL Challenge 11 was a practical problem. Given a a list of products and a list of discount coupons, we needed to find the minimum price for all the products based on certain rules. Here are those rules: Maximum two coupons can be applied on the same product The discount price can not be less than 70% of the original price The total amount of the discount can not exceed 30$ Also, note that coupons are applied in a cumulative way. So the second coupon is applied on the result of the o