Ex: The first code shows the usage of case in SELECT statement. And second code uses case in WHERE caluse to filter only BOLOGNO wins and also get rid of null values