create the required SQL statements to produce the following results

using the class example database (SQLFUN), create the required SQL statements to produce the following results:

3 SQL if-then-else statements

Clear and complete description for each of the above if-then-else queries

Results of each if-then-else query, clearly labeled