子查询我无法搞清楚

So I'm stuck on a problem that I'm trying to solve. I'm trying to "Select the Description of the most common delivery type". I execute it but I get no return. I even tried replacing the counts with the deliverytype ID's but even then I receive no output. what am I doing wrong ?So I'm stuck on a problem that I'm trying to so