need a select case statement that will add 2 fields after evaluating a calculation, in the case statement.

need a select case statement that will add 2 fields after evaluating a calculation

My data is here and i attached a workbook.


Column F (END DATE) HAS TO BE BEYOND todays date to evaluate.

For the "RANGE SCORE"  COMPARING   "G"  TO  "B" AND "C"
The criteria:



if the "sales sum" IS BELOW the "fromdollar" amount...The field gets populated with "BELOW RANGE"  
"Qualification Percent" gets populated with  0(zero)
if the "sales sum" IS ABOVE the "todollar" amount...The field gets populated with "ABOVE RANGE"      
"Qualification Percent" gets populated with  "BaseDiscountPercent" value
if the "sales sum" IS BETWEEN THE  "fromdollar" AND "TODOLLAR" amount...The field gets populated with "BETWEEN RANGE"  
"Qualification Percent" gets populated with  "BaseDiscountPercent" value

If the  "BaseDiscountPercent" value is null then the "Qualification Percent" gets populated with   "NONE STATED" value.

Here is my sql:

SELECT [contractNumber]
      ,[Fromdollar]
      ,[ToDollar]
      ,[BaseDiscountPercent]
      ,[StartDate]
      ,[EndDate]
     
     
  FROM [DATA].[dbo].[Tier_Discount]



Thanks
fordraiders
AA_RANGE_SQL.xlsx