There has been a little discussion about awk of late so just to drop a couple of resources
https://linuxhandbook.com/awk-command-tutorial/
https://www.gnu.org/software/gawk/manual/gawk.html
https://www.geeksforgeeks.org/linux-unix/gawk-command-in-linux-with-examples/
https://www.redhat.com/en/blog/beginners-guide-gawk
https://www.gnu.org/software/gawk/manual/gawk.pdf
https://www.oreilly.com/library/view/effective-awk-programming/9781491904930/
https://archive.org/details/GAWK_Effective_AWK_Programming/page/n49/mode/2up <<==== FREE
https://opensource.com/article/19/10/advanced-awk
https://www.tutorialspoint.com/awk/index.htm