how to calculate city Rank

Question

i want to calculate Student Rank by City wise depending on Score for each email id . but score details is in result table and City is in registration. Email id is common in both table. so how can i do it??? Thanx in advance.