SQL - Different where conditions for two columns

Just some programming note. When dealing with SQL database you can face the problem how to select two or more columns with different conditions. Here is the solution based on the CASE:

This problem is also discussed on internet for example here: http://stackoverflow.com/questions/3087314/sql-two-different-where-conditions-for-two-columns