-- Temprary Table の作成 --
WITH men_and_women AS (SELECT * FROM ( VALUES ('m1','man'),('m2','man'),('w1','woman'),('w2','woman'),('w3','woman') ) AS t(id,gender) )
-- 以下，temporary table: men_and_women を用いてのクエリ --
SELECT n1.id, n2.id, n1.id || ' ♥ ' || n2.id
FROM
(
  SELECT id, gender
  FROM men_and_women
) n1,
(
  SELECT id, gender
  FROM men_and_women
) n2
WHERE n1.id < n2.id AND n1.gender != n2.gender
ORDER BY n1.id, n2.id