CASE
statements will return any value you specify in your THEN
clause. This is an incredibly powerful tool for robust calculations and data manipulation when used in conjunction with an aggregate statement. One key task you can perform is using CASE
inside an AVG
function to calculate a percentage of information in your database.