Using CASE Expression in SQL Server to create a Computed Column

Here’s a practical and interesting example of using CASE expression in SQL Server. I am creating a computed column using CASE expression where I will automatically calculate the value of a column based on the value of other columns