Here ‘r’ (race) and ‘p’ (people) are being used as aliases for the lifeform and stplanets tables respectively
Use of Aliases is a Double Edged Sword, while in the short term the benefit is obvious, the first time you have to debug code with nested sub-queries all using clever aliases you will experience the point of the sword