| i |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |

набор        | вероятность
-------------+---------
(1, 2)       | 0.023
 (3, 5, 4)    | 0.039 
(1, 5)       | 0.31
(5, 3, 1)    | 0.21
(4, 2, 5, 1) | 0.0013
 (4, 3, 5)    | 0.039 

create table #t1 ( 
  id_t1 int IDENTITY( 1 , 1 ) primary key, s varchar( 100 ) 
)
go
create table #t2 ( 
  id_t2 int primary key,  probability dec(  4 , 3 )
)
go
create table #t3 ( 
  id_t1 int foreign key references #t1,  
  id_t2 int foreign key references #t2
   
  primary key(id_t1, id_t2) 
)
go
--------Заполняем #t1
insert into #t1 (s)
select top  10  name from sysobjects

--------Заполняем #t2
insert into #t2 ( id_t2, probability ) values(  1 ,  0 . 023  )
insert into #t2 ( id_t2, probability ) values(  2 ,  0 . 039  )
insert into #t2 ( id_t2, probability ) values(  3 ,  0 . 31  )

--------Заполняем #t3
--insert sequence (1, 2)
insert into #t3 ( id_t2, id_t1 ) values(  1 ,  1  )
insert into #t3 ( id_t2, id_t1 ) values(  1 ,  2  )

--insert sequence (3, 4, 5)
insert into #t3 ( id_t2, id_t1 ) values(  2 ,  3  )
insert into #t3 ( id_t2, id_t1 ) values(  2 ,  4  )
insert into #t3 ( id_t2, id_t1 ) values(  2 ,  5  )

--insert sequence (1, 5)
insert into #t3 ( id_t2, id_t1 ) values(  3 ,  1  )
insert into #t3 ( id_t2, id_t1 ) values(  3 ,  5  )

select id_t1 from #t1

id_t1       
----------- 
 1 
 2 
 3 
 4 
 5 
 6 
 7 
 8 
 9 
 10 

select * from #t2

id_t2       probability 
----------- ----------- 
 1            . 023 
 2            . 039 
 3            . 310 

select * from #t3

id_t1       id_t2       
----------- ----------- 
 1             1 
 1             3 
 2             1 
 3             2 
 4             2 
 5             2 
 5             3 

select 
  '(1, 2)' as "set",
  MIN(probability) as probability
from 
 #t2 join #t3 on #t2.id_t2 = #t3.id_t2
where
  #t3.id_t1 IN ( 1 ,  2 )
group by #t2.id_t2
having count(*) =  2 

set    probability 
------ ----------- 
( 1 ,  2 ) . 023  

select 
  '(3, 4, 5)' as "set",
  MIN(probability) as probability
from 
 #t2 join #t3 on #t2.id_t2 = #t3.id_t2
where
  #t3.id_t1 IN ( 3 ,  4 ,  5 )
group by #t2.id_t2
having count(*) =  3 

set       probability 
--------- ----------- 
( 3 ,  4 ,  5 ) . 039  

select 
  '(4, 3, 5)' as "set",
  MIN(probability) as probability
from 
 #t2 join #t3 on #t2.id_t2 = #t3.id_t2
where
  #t3.id_t1 IN ( 4 ,  3 ,  5 )
group by #t2.id_t2
having count(*) =  3 

set       probability 
--------- ----------- 
( 4 ,  3 ,  5 ) . 039  

select 
  '(1, 5)' as "set",
  MIN(probability) as probability
from 
 #t2 join #t3 on #t2.id_t2 = #t3.id_t2
where
  #t3.id_t1 IN ( 1 ,  5 )
group by #t2.id_t2
having count(*) =  2 

set    probability 
------ ----------- 
( 1 ,  5 ) . 310  

insert into #t2 ( id_t2, probability ) values(  4 ,  0 . 021  )

insert into #t3 ( id_t2, id_t1 ) values(  4 ,  9  )
insert into #t3 ( id_t2, id_t1 ) values(  4 ,  3  )
insert into #t3 ( id_t2, id_t1 ) values(  4 ,  4  )
insert into #t3 ( id_t2, id_t1 ) values(  4 ,  5  )
insert into #t3 ( id_t2, id_t1 ) values(  4 ,  8  )

select 
  '(9, 3, 4, 5, 8)' as "set",
  MIN(probability) as probability
from 
 #t2 join #t3 on #t2.id_t2 = #t3.id_t2
where
  #t3.id_t1 IN ( 9 ,  3 ,  4 ,  5 ,  8 )
group by #t2.id_t2
having count(*) =  5 

set             probability 
--------------- ----------- 
( 9 ,  3 ,  4 ,  5 ,  8 ) . 021 

--Выборка вероятности для набора (9, 3, 4, 5, 8)

select
  '(9, 3, 4, 5, 8)' as "set",
  MIN(probability) as probability
from 
( select 
    #t2.id_t2,
    MIN(probability) as probability
  from 
   #t2 join #t3 on #t2.id_t2 = #t3.id_t2
  group by #t2.id_t2
  having count(*) =  5 
) as groups
 join 
 #t3 on groups.id_t2 = #t3.id_t2
where
  #t3.id_t1 IN ( 9 ,  3 ,  4 ,  5 ,  8 )
group by groups.id_t2
having count(*) =  5 


set             probability 
--------------- ----------- 
( 9 ,  3 ,  4 ,  5 ,  8 ) . 021 

--Выборка вероятности для набора (3, 4, 5)

select
  '(3, 4, 5)' as "set",
  MIN(probability) as probability
from 
( select 
    #t2.id_t2,
    MIN(probability) as probability
  from 
   #t2 join #t3 on #t2.id_t2 = #t3.id_t2
  group by #t2.id_t2
  having count(*) =  3 
) as groups
 join 
 #t3 on groups.id_t2 = #t3.id_t2
where
  #t3.id_t1 IN ( 3 ,  4 ,  5 )
group by groups.id_t2
having count(*) =  3 

set       probability 
--------- ----------- 
( 3 ,  4 ,  5 ) . 039 

SELECT * from AT2 where id_t2 in(
select id_t2 from AT3
where id_t2 in
(
select id_t2 from AT3 where id_t1 =  3  
INTERSECT
select id_t2 from AT3 where id_t1 =  4 
INTERSECT
select id_t2 from AT3 where id_t1 =  5 
)
group by id_t2
having count(*) =  3 )

SELECT * from AT2 where id_t2 in (

SELECT * from AT2 where id_t2 = (

select * from #t2 
where id_t2 = 
(
  select groups.id_t2 from #t3
  join 
  ( select id_t2
      from #t3
      group by id_t2
      having count(*) =  3  --ЧИСЛО ЗНАЧЕНИЙ СПИСКА
    ) as groups
    on groups.id_t2 = #t3.id_t2
  where
    #t3.id_t1 IN ( 3 ,  4 ,  5 ) --СПИСОК
  group by groups.id_t2
  having count(*) =  3  --ЧИСЛО ЗНАЧЕНИЙ СПИСКА
)