row difference validation

I have above table name as reservation. now i need to validate if difference is  DifferentalrCost (D) column is correct. As you can see i can validate manual but how can i do in large scale. basically, column D represent the difference between column C rows.  Is there any way I can validate as true statement. Can someone help me with quarry.