Exercise 19: Logic and Math Expressions

The SQLite3 language supports many more functions to handle math, string manipulation, grouping, types, and other features in the SQLite3 Core Functions documentation. The only catch is sometimes you'll want to use the AS keyword to assign these results to a fake column name. It's best to always give math expressions a column name with AS from now on, but if you ever type out an expression and don't see it, that's why. To use AS just do this: