SELECT p.name AS package_name, COUNT(o.id) AS package_order_count, COUNT(o.id)/(SELECT COUNT(id) FROM t_order) AS proportion FROM t_package AS p INNER JOIN t_order AS o ON p.id=o.package_id GROUP BY package_name ORDER BY package_name DESC LIMIT 0,4
表结构与关联关系如下图:SELECTp.name AS package_name,COUNT(o.id) AS package_order_count,COUNT(o.id)/(SELECT COUNT(id) FROM t_order) AS proportionFROM t_package AS p INNER JOIN t_order AS o ON p.id=o.package_idGROUP BY package_nameORDER BY package_name DESCLIM