Job-Ready SQL in an Afternoon - Creating New Columns and Arithmetic

The video tutorial covers performing various operations on table columns using SQL. It starts with converting a bytes column to kilobytes by dividing by 1024. The tutorial then explores arithmetic operations like multiplication, subtraction, and addition on columns. It demonstrates using other columns for operations, such as calculating bytes per millisecond. The video also explains ordering results by calculated columns and using parentheses for complex operations to dictate the order of operations.

What is the purpose of using an alias when performing operations on columns?

Describe how parentheses can affect the order of operations in SQL queries.

What are some examples of modifications that can be made to columns in a database?