Creating a New Column and Calculating Each Element with Conditions in R

How to Correctly Create a Calculated Column in SQL Using CASE Statement and Avoid Syntax Errors