Very eye opening presentation and good exercises in the second video!
I had no understanding of awk whatsoever and can now fully grok the following command, which returns the number of different cities in a structured file with a header line, addresses and the city in column 5:
awk 'NR != 1 { print $5 }' payroll.tsv | sort | uniq | wc -l
This is beautiful.