查询已婚、未婚的男性、女性、未婚女性的gender=Male和性别=女性

Question

我在用PostgreSQL。我想数一数：

where gender='M'

• ladies

1. 先生结婚了，先生们未婚
   1. 结婚了，女士们未婚where gender='F'
   2. Total结婚了伯爵和未婚伯爵。--

我只能执行先生已婚和先生未婚或女士结婚和女士未婚where gender=?，但我无法执行以下整个查询。所以，谁能给我更正一下下面的代码。

SELECT COUNT(CASE
               WHEN married = 'M' THEN
                1
             END) AS gentlemen_married WHERE gender = 'M',
       COUNT(CASE
               WHEN married = 'U' THEN
                1
             END) AS gentlemen_unmarried WHERE gender = 'M',
       COUNT(CASE
               WHEN married = 'M' THEN
                1
             END) AS ladies_married WHERE gender = 'F',
       COUNT(CASE
               WHEN married = 'U' THEN
                1
             END) AS ladies_unmarried WHERE gender = 'F',
       COUNT(*) AS married_COUNT WHERE married = 'M',
       COUNT(*) AS unmarried_COUNT WHERE married = 'U'
  FROM station
 WHERE group = 'abc';

Answer 1

我尝试过许多方法，最后，下面的代码适用于我：

SELECT Sum(CASE
             WHEN married = 'M'
                  AND gender = 'M' THEN 1
             ELSE 0
           END) AS gentlemen_married,
       Sum(CASE
             WHEN married = 'U'
                  AND gender = 'M' THEN 1
             ELSE 0
           END) AS gentlemen_unmarried,
       Sum(CASE
             WHEN married = 'M'
                  AND gender = 'F' THEN 1
             ELSE 0
           END) AS ladies_married,
       Sum(CASE
             WHEN married = 'U'
                  AND gender = 'F' THEN 1
             ELSE 0
           END) AS ladies_unmarried,
       Sum(CASE
             WHEN married = 'M' THEN 1
             ELSE 0
           END) AS married_count,
       Sum(CASE
             WHEN married = 'U' THEN 1
             ELSE 0
           END) AS unmarried_count
FROM   station
WHERE  rrcode = 'abc';