how to use case statements in SQL
In recent posts on SQL here on this website, we have covered off a number of ways to extract your data from wildcards to filters. Here we are going to build on that learning, but bring in a new dimension in the use of case statements. These are very handy to use when you may…