doryokujin doryokujin

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

## result_trump_part_same
symbol  symbol  number  number
♡	♡	1	4
♡	♡	1	5
♡	♡	1	8
♡	♡	1	9
♡	♡	1	11
♡	♡	1	12
♡	♡	4	5

## combination_trump_part_aggr.sql
SELECT number1, number2, COUNT(1) AS cnt
FROM
(
  SELECT n1.symbol,n2.symbol, n1.number AS number1, n2.number AS number2
  FROM
  (
    SELECT number, symbol
    FROM trump_part
    WHERE symbol!='joker'
  ) n1

## result_trump_part_aggr
number1  number2  cnt
1	8	3
3	8	3
3	13	3
8	9	3
8	11	3
8	13	3
1	3	2
1	9	2
1	11	2

## basket_times
アイテム1  アイテム2  共起回数
1	8	3
3	8	3
3	13	3
8	9	3
8	11	3
8	13	3
1	3	2
1	9	2
1	11	2

## gist:c56951f8aa8d07384755
レシートID  レシートID  アイテムID  アイテムID
♡	♡	1	4
♡	♡	1	5
♡	♡	1	8
♡	♡	1	9
♡	♡	1	11
◆	◆	1	12
◆	◆	4	5

## combination_trump_all.sql
SELECT n1.number, n2.number, n1.symbol, n2.symbol
FROM
(
  SELECT symbol,number
  FROM trump
) n1,
(
  SELECT symbol,number
  FROM trump
) n2

## result_combination_trump_all
number  number  symbol  symbol
0	0	joker	joker
0	1	joker	♡
0	1	joker	♣
0	1	joker	♤
...

## combination_trump_triplet.sql
SELECT n1.number, n2.number, n3.number, n1.symbol, n2.symbol, n3.symbol
FROM
(
  SELECT symbol,number
  FROM trump
) n1,
(
  SELECT symbol,number
  FROM trump
) n2,

## result_combination_trump_triplet
number  number  number  symbol  symbol  symbol
0	0	0	joker	joker	joker
0	0	1	joker	joker	♡
0	0	1	joker	joker	♣
...
	SELECT n1.symbol,n2.symbol, n1.number, n2.number
	FROM
	(
	SELECT number, symbol
	FROM trump_part
	WHERE symbol!='joker'
	) n1
	JOIN
	(
	SELECT number, symbol
	symbol symbol number number
	♡ ♡ 1 4
	♡ ♡ 1 5
	♡ ♡ 1 8
	♡ ♡ 1 9
	♡ ♡ 1 11
	♡ ♡ 1 12
	♡ ♡ 4 5
	SELECT number1, number2, COUNT(1) AS cnt
	FROM
	(
	SELECT n1.symbol,n2.symbol, n1.number AS number1, n2.number AS number2
	FROM
	(
	SELECT number, symbol
	FROM trump_part
	WHERE symbol!='joker'
	) n1
	number1 number2 cnt
	1 8 3
	3 8 3
	3 13 3
	8 9 3
	8 11 3
	8 13 3
	1 3 2
	1 9 2
	1 11 2
	アイテム1 アイテム2 共起回数
	1 8 3
	3 8 3
	3 13 3
	8 9 3
	8 11 3
	8 13 3
	1 3 2
	1 9 2
	1 11 2
	レシートID レシートID アイテムID アイテムID
	♡ ♡ 1 4
	♡ ♡ 1 5
	♡ ♡ 1 8
	♡ ♡ 1 9
	♡ ♡ 1 11
	◆ ◆ 1 12
	◆ ◆ 4 5
	SELECT n1.number, n2.number, n1.symbol, n2.symbol
	FROM
	(
	SELECT symbol,number
	FROM trump
	) n1,
	(
	SELECT symbol,number
	FROM trump
	) n2
	number number symbol symbol
	0 0 joker joker
	0 1 joker ♡
	0 1 joker ♣
	0 1 joker ♤
	...
	SELECT n1.number, n2.number, n3.number, n1.symbol, n2.symbol, n3.symbol
	FROM
	(
	SELECT symbol,number
	FROM trump
	) n1,
	(
	SELECT symbol,number
	FROM trump
	) n2,
	number number number symbol symbol symbol
	0 0 0 joker joker joker
	0 0 1 joker joker ♡
	0 0 1 joker joker ♣
	...