SQL Server

Question1. You will need to bucket the entire ParkingCitations database into three segments by ViolFine. Your first segment will include records with ViolFine between $0.00 and $50.00 and will be labled as "01. $0.00 - $50.00". The second segment will include records with ViolFine between $50.01 and $100.00 and will be labled as "02. $50.01 - $100.00". The final segment will include records with ViolFine larger than $100.00 and will be labled as"03. larger than $100.00".

Display Citation, Make, VioCode, VioDate, VioFine, and the Segment information in an descending order of ViolDate.