When I query an Amazon Athena table that has defined partitions, zero records are returned

For more details see the Knowledge Center article with this video: https://amzn.to/36DaM71
Kunal shows you why creating a table in Amazon Athena with defined partitions, but when you query the table, zero records are returned.

This is a companion discussion topic for the original entry at https://www.youtube.com/watch?v=afhG5l6GG4w