The covid analysis seems like a pretty good example: https://colab.research.google.com/github/EvgSkv/logica/blob/...

A good exercise might be converting it to the corresponding SQL and comparing the two for clarity.