Game-Set-Match/[set]box-script.sql at main · patch72/Game-Set-Match · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
with cards as
 (          select 1 cardno, 'oval'     symbol, 'red'    color, 'open'    shading, 2 qty from dual
  union all select 2       , 'squiggle'       , 'purple'      , 'solid'          , 1     from dual
  union all select 3       , 'diamond'        , 'red'         , 'solid'          , 3     from dual
  union all select 4       , 'squiggle'       , 'green'       , 'solid'          , 3     from dual
  union all select 5       , 'diamond'        , 'red'         , 'striped'        , 1     from dual
  union all select 6       , 'oval'           , 'purple'      , 'striped'        , 1     from dual
  union all select 7       , 'oval'           , 'red'         , 'open'           , 1     from dual
  union all select 8       , 'oval'           , 'purple'      , 'open'           , 1     from dual
  union all select 9       , 'oval'           , 'green'       , 'solid'          , 2     from dual
  union all select 10      , 'oval'           , 'purple'      , 'solid'          , 1     from dual
  union all select 11      , 'oval'           , 'red'         , 'open'           , 3     from dual
  union all select 12      , 'diamond'        , 'purple'      , 'striped'        , 1     from dual)
select *
  from      cards cards1
 cross join cards cards2
 cross join cards cards3
 where cards1.cardno < cards2.cardno
   and cards2.cardno < cards3.cardno
   and (   (    cards1.symbol  =  cards2.symbol
            and cards1.symbol  =  cards3.symbol
           )
        or (    cards1.symbol  <> cards2.symbol
            and cards2.symbol  <> cards3.symbol
            and cards1.symbol  <> cards3.symbol
           )
       )
   and (   (    cards1.color   =  cards2.color
            and cards1.color   =  cards3.color
           )
        or (    cards1.color   <> cards2.color
            and cards2.color   <> cards3.color
            and cards1.color   <> cards3.color
           )
       )
   and (   (    cards1.shading =  cards2.shading
            and cards1.shading =  cards3.shading
           )
        or (    cards1.shading <> cards2.shading
            and cards2.shading <> cards3.shading
            and cards1.shading <> cards3.shading
           )
       )
   and (   (    cards1.qty     =  cards2.qty
            and cards1.qty     =  cards3.qty
           )
        or (    cards1.qty     <> cards2.qty
            and cards2.qty     <> cards3.qty
            and cards1.qty     <> cards3.qty
           )
       )