List LLD rules, classify by the discovery cycle

Show all LLD rulles by execution time and discovery key. show the count of rules:

select delay,key_,count(*) from items where flags = 1 group by delay, key_ order by delay,count(*);

Sort LLD rules by execution cycle interval:

SELECT count(*),delay from items where flags = 1 GROUP BY delay ORDER BY count(*);