It's unethical to copy someone's work - I'll not do it. It's illegal as well as shameful. Here is my query:

with MyTesttable AS

(

select partyID, BillNo, TotalRollNo, OwnerName, TotalTax, SchoolDistrict, ClassCode,...