Fig. Mayor

Fig. City Hall

Did anyone become a Mayor where the difference commencement year (yr_comm) and birth year (birth_yr) is greater than or equal to 50? If so, then please list the name of mayor, the party that they led, birth year, and commencement year? Write the SQL query to answer the question.

mayor_name A. Myers B. Byers C. Susan D. Parker B. Scott | A. Mary birth_year 1856 1845 1886 1850 1860 1855 yrs_served 2.8 2.5 1.3 1.9 state_born California Texas Hawaii state_rep California Texas Hawaii Arizona Florida Virginia Florida 3.5 mayor_nr party mayor_name B. Scott A. Myers D. Parker B. Scott A. Myers B. Byers Yr_comm 1901 1902 1919 1905 1902 1908 6