CREATE TABLE lists (
  listId int,
  itemId int,
  PRIMARY KEY (listId, itemId)
);

select listId
from lists
where itemId in (10, 20, 30)
group by listId
having count(distinct itemId) = 3;

q
  .groupBy(_.listId)
  .map {
    case (listId, group) => (listId, group.map(_.itemId).filter(_ inSet Set(10, 20, 30)).countDistinct)
  }
  .filter(_._2 > 3)

scala.slick.SlickException: No type for symbol s2 found for Ref s2
  at scala.slick.ast.Ref.nodeWithComputedType2(Node.scala:501) ~[slick_2.11-2.1.0.jar:na]