two "when" conditions in sql code example

Example: sql two conditions

SELECT column1, column2, columnN 
FROM table_name
WHERE [condition1] AND [condition2]...AND [conditionN];