String Functions: CONCAT, SUBSTRING, ... Another important concept to know here is partitioning which allows you to apply window functions on a selection of ... Date and time functions are SQL ...