code: package it.unibz.inf.ontop.docker.lightweight.snowflake;
  
  import com.google.common.collect.ImmutableMap;
  import com.google.common.collect.ImmutableSet;
  import it.unibz.inf.ontop.docker.lightweight.AbstractDistinctInAggregateTest;
  import it.unibz.inf.ontop.docker.lightweight.SnowflakeLightweightTest;
  import org.junit.jupiter.api.AfterAll;
  import org.junit.jupiter.api.BeforeAll;
  import org.junit.jupiter.api.Disabled;
  import org.junit.jupiter.api.Test;
  
  import java.io.IOException;
  import java.sql.SQLException;
  
  @SnowflakeLightweightTest
  public class DistinctInAggregateSnowflakeTest extends AbstractDistinctInAggregateTest {
  
      private static final String PROPERTIES_FILE = "/university/university-snowflake.properties";
  
      @BeforeAll
      public static void before() throws IOException, SQLException {
          initOBDA("/university/university-snowflake.obda", OWL_FILE, PROPERTIES_FILE);
      }
  
      @AfterAll
      public static void after() throws SQLException {
          release();
      }
  
      @Override
      protected ImmutableSet<ImmutableMap<String, String>> getTuplesForAvg() {
          return ImmutableSet.of(
                  ImmutableMap.of(
                          "p",buildAnswerIRI("1"),
                          "ad", "\"10.500\"^^xsd:decimal"
                  ),
                  ImmutableMap.of(
                          "p",buildAnswerIRI("3"),
                          "ad", "\"12.000\"^^xsd:decimal"
                  ),
                  ImmutableMap.of(
                          "p",buildAnswerIRI("8"),
                          "ad", "\"13.000\"^^xsd:decimal"
                  )
          );
      }
  }
  