Shelf Engine Interview Question

Some trivially simple Python. Writing a case statement for a simple select in SQL.