Here we cover:

• Using sub-queries
• Using LEAD and LAG to access prior or subsequent rows
• Rounding numerical data
• Selecting random samples of data
• Extracting parts of a date ( i.e. month, year, day, day of week )
• Working with strings/text