id   name
--   -----------
01   ginger beer
02   white wine
03   red wine
04   ginger wine

comment           total
---------------   -----
contains ginger   2
for wine lovers   3

SELECT * FROM
(
  (
    SELECT
      'contains ginger' AS comment,
      sum((name LIKE '%ginger%')::INT) AS total
    FROM foods
  )
  UNION ALL
  (
    SELECT
      'for wine lovers' AS comment,
      sum((name LIKE '%wine%')::INT) AS total
    FROM foods
  )
)

SELECT
  sum((name LIKE '%ginger%')::INT) AS contains_ginger,
  sum((name LIKE '%wine%')::INT) AS for_wine_lovers
FROM foods

contains_ginger   for_wine_lovers
---------------   ---------------
2                 3