search: Import popularity score from airflow 1
Direct port of popularity score for airflow 1. This is a very simple hql invocation with no significant changes for airflow 2. The rendering has been checked manually against the output of the airflow 1 instance and everything looks to have stayed the same.
Bug: T329878