SQL table aliases

[cyouh95]

You could also use table aliases to avoid having to write out the full name each time:

SELECT v.first_name, ... f.fitness_test_date, ...
FROM visits v
    LEFT JOIN fitness_tests f
        ON v.email=f.email
        AND v.first_name=f.first_name
        AND v.last_name=f.last_name
    ...
WHERE v.visit_date >= '7-1-17';

https://github.com/matthewboehlke/intro-data-capstone-musclehub/blob/master/Intro_To_Data_Analysis_Matt_Boehlke/musclehub.py#L121-L135