SQL搜索,在表中搜索a | b | c | d,并返回按记录中元素数排序的结果

select 
    day_name, count(day_name) qty
from
    actions
where 
    name in ('eat', 'sleep', 'write', 'drink')
group by day_name
order by qty desc

SELECT d.name
    FROM ACTIONS a JOIN DAYS d ON a.day_name=d.name
        WHERE a.name IN ('eat', 'sleep', 'write', 'drink')  -- Your search
            GROUP BY a.name
                ORDER BY COUNT(*) DESC;

你在找这个。。。

SELECT day_name, number FROM
(
  SELECT day_name, COUNT(*) 
  FROM ACTIONS 
  WHERE name in ('eat', 'sleep', 'write') 
  GROUP BY day_name
) AS Test
ORDER BY number DESC