Table: constellations_area
Columns: rank
family
abbre_viation
constellation
area_sq_deg
area_msr
per_cent_age
right_ascension_hm
decli_nation_dm
quad

Question: What is the largest Area (msr) that has an Area less than 291.045, is part of the Per family, and has a rank higher than 78?
SQL: SELECT MAX("area_msr") FROM constellations_area WHERE "area_sq_deg" < 291.045 AND "family" = 'per' AND "rank" > 78

Question: What is the total sum of Areas (sq.deg) that have an Area (msr) of 43.059 and a Right ascension (hm) larger than 747.73?
SQL: SELECT SUM("area_sq_deg") FROM constellations_area WHERE "area_msr" = 43.059 AND "right_ascension_hm" > 747.73