SELECT young_people_rank,
       walkability_rank,
       tax_competitiveness_rank,
       summer_job_rank,
       single_people_rank,
       savings_rank,
       salary_to_own_a_home_rank,
       retirement_rank,
       reading_rank,
       pediatric_care_rank,
       nightlife_rank,
       gay_pride_rank,
       foodies_rank,
       finding_a_woman_rank,
       finding_a_man_rank,
       finance_and_accounting_jobs_rank,
       dog_bites_rank,
       bed_bugs_rank2,
       weed_friendliness_rank,
       to_live_rank,
       romance_rank,
       promiscuity_rank,
       overdraft_fees_rank,
       music_scenes_rank,
       innovative_workers_rank,
       bed_bugs_rank,
       atm_fees_rank,
       asthma_rank,
       number_of_pizza_places_rank,
       number_of_bars_rank,
       city,
       state,
       citystate,
       ( young_people_rank + walkability_rank
         + tax_competitiveness_rank + summer_job_rank
         + single_people_rank + savings_rank
         + salary_to_own_a_home_rank + retirement_rank
         + reading_rank + pediatric_care_rank
         + nightlife_rank + gay_pride_rank + foodies_rank
         + finding_a_woman_rank + finding_a_man_rank
         + finance_and_accounting_jobs_rank
         + dog_bites_rank + bed_bugs_rank2
         + weed_friendliness_rank + to_live_rank
         + romance_rank + promiscuity_rank
         + overdraft_fees_rank + music_scenes_rank
         + innovative_workers_rank + bed_bugs_rank
         + atm_fees_rank + asthma_rank
         + number_of_pizza_places_rank
         + number_of_bars_rank )                             AS sumRank,
       ( young_people_rank + walkability_rank
         + tax_competitiveness_rank + summer_job_rank
         + single_people_rank + savings_rank
         + salary_to_own_a_home_rank + retirement_rank
         + reading_rank + pediatric_care_rank
         + nightlife_rank + gay_pride_rank + foodies_rank
         + finding_a_woman_rank + finding_a_man_rank
         + finance_and_accounting_jobs_rank
         + dog_bites_rank + bed_bugs_rank2
         + weed_friendliness_rank + to_live_rank
         + romance_rank + promiscuity_rank
         + overdraft_fees_rank + music_scenes_rank
         + innovative_workers_rank + bed_bugs_rank
         + atm_fees_rank + asthma_rank
         + number_of_pizza_places_rank
         + number_of_bars_rank ) /
       (SELECT MAX("young_people_rank" +
                   "walkability_rank"
                   + "tax_competitiveness_rank"
                   + "summer_job_rank" +
                   "single_people_rank"
                   + "savings_rank"
                   + "salary_to_own_a_home_rank"
                   + "retirement_rank" +
                   "reading_rank"
                   + "pediatric_care_rank" +
                   "nightlife_rank"
                   + "gay_pride_rank" +
                   "foodies_rank"
                   + "finding_a_woman_rank"
                   + "finding_a_man_rank"
                   + "finance_and_accounting_jobs_rank"
                   + "dog_bites_rank" + "bed_bugs_rank2"
                   + "weed_friendliness_rank" +
                   "to_live_rank"
                   + "romance_rank" + "promiscuity_rank"
                   + "overdraft_fees_rank" +
                   "music_scenes_rank"
                   + "innovative_workers_rank" +
                   "bed_bugs_rank"
                   + "atm_fees_rank" + "asthma_rank"
                   + "number_of_pizza_places_rank"
                   + "number_of_bars_rank")
        FROM   cityranks) AS total_norm
FROM   cityranks;