| select | |
| c_count, | |
| count(*) as custdist | |
| from | |
| ( | |
| select | |
| c_custkey, | |
| count(o_orderkey) | |
| from | |
| customer left outer join orders on | |
| c_custkey = o_custkey | |
| and o_comment not like '%special%requests%' | |
| group by | |
| c_custkey | |
| ) as c_orders (c_custkey, c_count) | |
| group by | |
| c_count | |
| order by | |
| custdist desc, | |
| c_count desc; |