SQL Server Query

Hello I got a SQL Server with a table with sales by: -date -customer -family ( 2 values "S" and "N") -Amount -supplier By other side I have a table with discount to apply to some clients depending on a selecion related to the fields mentioned (customer, family supplier). There are many rows depending on total amount in a period. You will apply the conditions you have in Discount table to fact table (select client, family, supplier for the period), sum amount selected and inform the discount depending on the total amount. For example: 0 to 99 ==>1% 100 to 199 ==> 2% 200 to 9999 ==> 3% If total selected is 120, then u will inform that the discount will be a 2%. Your output will be a view with the same values in original table + the values of the discount applied, initial date, end date and % (records you find in discount table). Thanks