只是猜测

with cte as ( 
             -- Your Query -- 
            )
Select Results = case when max( case when gender='M' then [frequency] end)
                           >
                           max( case when gender='F' then [frequency] end)
                       then 'true' else 'false' end
 From  cte

结果

Results
false

请尝试以下解决方案。

SQL语言

-- DDL and sample data population, start
DECLARE @tbl TABLE (gender CHAR(1), frequency INT);
INSERT @tbl (gender, frequency) VALUES
('F', 34),
('M', 10);
-- DDL and sample data population, end

;WITH rs AS
(
    SELECT * 
        , MAX(frequency) OVER (ORDER BY gender) AS max_frequency
    FROM @tbl
)
SELECT rs.gender
    , result = IIF(rs.max_frequency = rs.frequency, 'true', 'false')
FROM rs;

产出

| 性别|结果|
| - ------|- ------|
| F级|真|
| 男|假的|