COALESCE is handy too depending on the nature of your if-else and your data. Since it takes in multiple arguments and returns the first non-null value, it's good for "if this field is null then give me that other field". Good write up though, thanks!