Functions in in interviews not in list

I’ve been over half of the interviews and I’ve found a few functions you used that are not in the list such as rank, trunc date, dow.
I learned SQL at university years ago and wanted to refresh, so I also went through the full SQL course in the 365 program. There are a bunch of functions in your list + several from the interviews that are not touched there. It’s a shame. :(