You can use the CASE statement to compare values ... To write a simple CASE statement in SQL, follow this basic syntax: SELECT CASE column_name WHEN value1 THEN result1 WHEN value2 THEN result2 ...

Explaining the theoretical and physical aspects of a relational database Relating clauses in SQL Select Statement to Components of an ERD Explaining the relationship between a database and SQL ...