PHP MySQL Count总问题

SELECT
    GROUP_CONCAT(DISTINCT nextgenorder_companyname) AS nextgenorder_companyname,
    GROUP_CONCAT(DISTINCT nextgenorder_company_entity) AS nextgenorder_company_entity,
    GROUP_CONCAT(DISTINCT nextgenorder_ordernumber) AS nextgenorder_ordernumber,
    GROUP_CONCAT(DISTINCT nextgenorder_deliverydate) AS nextgenorder_deliverydate
FROM nextgenorders2
WHERE nextgenorder_deliverydate='2020-11-11'
GROUP BY SUBSTRING_INDEX(REPLACE(nextgenorder_companyname, '/', ' '), ' ',1)
ORDER BY SUBSTRING_INDEX(REPLACE(nextgenorder_companyname, '/', ' '), ' ',1)

SQL Fiddle Example

我试过这个:

SELECT 
count(DISTINCT nextgenorder_company_entity) as company, 
nextgenorder_deliverydate as ShipDate 
FROM nextgenorders2 
WHERE nextgenorder_deliverydate='2020-11-11' 
    GROUP BY nextgenorder_deliverydate

SQL Fiddle Example

SELECT GROUP_CONCAT(nextgenorder_companyname) AS nextgenorder_companyname,
GROUP_CONCAT(nextgenorder_deliverydate) nextgenorder_deliverydate
  FROM
(
  SELECT COUNT(*) Total
    FROM nextgenorders2
  WHERE nextgenorder_deliverydate='2020-11-11'
 GROUP BY SUBSTRING_INDEX(REPLACE(nextgenorder_companyname, '/', ' '), ' ',1)

) q

SELECT count(DISTINCT SUBSTRING_INDEX(REPLACE(nextgenorder_companyname, '/', ' '), ' ',1) ) as company, nextgenorder_deliverydate as ShipDate FROM nextgenorders2 WHERE nextgenorder_deliverydate = '2020-11-11' GROUP BY nextgenorder_deliverydate;