Question

I need help with getting these SQL codes please, I can run them myself. I just need the codes

1. Create a risk ranking of returned items in 2014. Create a new column of data that shows whether something is high risk, medium risk or low risk based on the following criteria. If the return was equal to or more than $1,000, it is high risk; if the return is equal to or more than $500 and less than $1,000, it is medium risk; and if the return is less than $500, it is low risk. Display the year, name of the cardholder, description, vendor, amount of return and the new column (labeled RiskRanking). Sort the data so that the largest returns are listed first, and do not list any data that is not a return. As a hint, remember that returns are listed as negative numbers — make sure to think about this carefully.  

Answer 1

-- As per question I hope all columns are in same table. I will be using table name ITEM and column names as per question. Please modify if table or column are wrong. Please let me know if all columns are not fro! One column so I can modify accordingly.

Select year,CardHolderName,description, vendor,amount, Case when amount <'-1000 then 'highrisk' when amount <='-1000' and amount >'-500' them 'medium risk' else 'low risk' end as RiskRanking From items where amount <0 order by 6 asc;

As amount are in negative we need to do opposite of positive symbols.