Part 5/5 of Lead Engagement Scoring Query: https://gist.github.com/henryhund/dc9b2d47c00f018c098c#file-lead_scoring_complete_query-sql

part_5_lead_scores.sql

/*
This is the final part of this query, which gives us leads ordered by aggregate score!
Include Parts 1, 2, 3 and 4
*/
SELECT  sum(mrr_per_visit) as lead_score,
        prospect_id
FROM all_prospects_visits 
JOIN mrr_per_activity
ON all_prospects_visits.visit_type = mrr_per_activity.visit_type
AND all_prospects_visits.visit_details = mrr_per_activity.visit_details
GROUP BY prospect_id
ORDER BY lead_score DESC