关联查询

select aq.informid, aq.title, count(a.itemid) count
  from AQ2022 aq
  left join aq2024 a
    on aq.informid = a.informid
 where 1 = 1
   and aq.title is not null
 group by aq.informid, aq.title
 order by count(a.itemid)