On their own, the Order By
statement and the Peek
function are already powerful. Now, imagine what happens when we combine both of these tools to enhance our input data. In this section, we will use both of these functions to add a new calculated field to our Employment
table (the one we integrated to our data model in Chapter 8, Data Modeling Best Practices).
The Employment
table provides information regarding the monthly number of employees per airline. The total number is split between part and full time employees, and it also shows the total
FTEs (Full Time Equivalent).