retrieve the total number of transactions for each customercid。show them in descending order by the total number of transactions
SELECT cid, COUNT(*) AS total_transactions FROM transactions GROUP BY cid ORDER BY total_transactions DESC;
原文地址: https://www.cveoy.top/t/topic/eYI6 著作权归作者所有。请勿转载和采集!