正确的ORDER BY基于同一表中的关联项查询项目

I want to rank a list of bundled products (each bundle is a singular item in the table) that is based on the aggregate number of its individual components (which are each singular items in the same table) sold.I want to rank a list of bundled products (each