SQL Syntax error in Select statement

SQL
1

Select first_name, Last_name, birth_date, (if year(birth_date>=1991),“New_birth”,“Old_birth”) as Birth
from customers

The “Error says is not valid at this position for this server Verizon” Though the code is correct. The error is because I’m using If & case statement only. Could you please look into this?

Thanks!
Regards
Ravi

2

Hi, I’ve figured out this.

Thanks!