doryokujin doryokujin

## result_matching_mistake
id  id  pair
m1	m2	m1 ♥ m2
m1	w1	m1 ♥ w1
m1	w2	m1 ♥ w2
m1	w3	m1 ♥ w3
m2	w1	m2 ♥ w1
m2	w2	m2 ♥ w2
m2	w3	m2 ♥ w3
w1	w2	w1 ♥ w2
w1	w3	w1 ♥ w3

## get_matching_correct.sql
SELECT n1.id, n2.id, n1.id || ' ♥ ' || n2.id
FROM
(
  SELECT id, gender
  FROM men_and_women
) n1
JOIN
(
  SELECT id, gender
  FROM men_and_women

## gist:73c4575b02ae8723bfad
id  id  pair
m1	w1	m1 ♥ w1
m1	w2	m1 ♥ w2
m1	w3	m1 ♥ w3
m2	w1	m2 ♥ w1
m2	w2	m2 ♥ w2
m2	w3	m2 ♥ w3

## trump
symbol,number
diamond,1
...
diamond,13
spade,1
...
spade,13
heart,1
...
heart,13

## trump
symbol,number
♦,1
...
♦,13
♤,1
...
♤,13
♣,1
...
♣,13

## combination_trump_not-same-symbol.sql
SELECT n1.symbol,n2.symbol, n1.number, n2.number
FROM
(
  SELECT number, symbol
  FROM trump
  WHERE symbol!='joker'
) n1
JOIN
(
  SELECT number, symbol

## combination_trump_same.sql
SELECT n1.symbol,n2.symbol, n1.number, n2.number
FROM
(
  SELECT number, symbol
  FROM trump
  WHERE symbol!='joker'
) n1
JOIN
(
  SELECT number, symbol

## result_trump_same
symbol  symbol  number  number
♡	♡	1	2
♡	♡	1	3
...
♡	♡	1	13
♡	♡	2	3
...

## result_trump_not-same
symbol  symbol  number  number
♡	♣	1	1
♡	♣	1	2
...
♡	♣	2	1
...

## trump_part
symbol,number
♦,1
♦,3
♦,6
♦,8
♦,10
♦,11
♦,13
♤,1
♤,3
	id id pair
	m1 m2 m1 ♥ m2
	m1 w1 m1 ♥ w1
	m1 w2 m1 ♥ w2
	m1 w3 m1 ♥ w3
	m2 w1 m2 ♥ w1
	m2 w2 m2 ♥ w2
	m2 w3 m2 ♥ w3
	w1 w2 w1 ♥ w2
	w1 w3 w1 ♥ w3
	SELECT n1.id, n2.id, n1.id \|\| ' ♥ ' \|\| n2.id
	FROM
	(
	SELECT id, gender
	FROM men_and_women
	) n1
	JOIN
	(
	SELECT id, gender
	FROM men_and_women
	symbol,number
	diamond,1
	...
	diamond,13
	spade,1
	...
	spade,13
	heart,1
	...
	heart,13
	SELECT n1.symbol,n2.symbol, n1.number, n2.number
	FROM
	(
	SELECT number, symbol
	FROM trump
	WHERE symbol!='joker'
	) n1
	JOIN
	(
	SELECT number, symbol
	symbol symbol number number
	♡ ♡ 1 2
	♡ ♡ 1 3
	...
	♡ ♡ 1 13
	♡ ♡ 2 3
	...
	symbol symbol number number
	♡ ♣ 1 1
	♡ ♣ 1 2
	...
	♡ ♣ 2 1
	...
	symbol,number
	♦,1
	♦,3
	♦,6
	♦,8
	♦,10
	♦,11
	♦,13
	♤,1
	♤,3