CreateQuery uk_price_paid (children 3)
 Identifier uk_price_paid
 Columns definition (children 3)
  ExpressionList (children 16)
   ColumnDeclaration Table (children 1)
    DataType String
   ColumnDeclaration Engine (children 1)
    DataType String
   ColumnDeclaration price (children 1)
    DataType UInt32
   ColumnDeclaration date (children 1)
    DataType Date
   ColumnDeclaration postcode1 (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
   ColumnDeclaration postcode2 (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
   ColumnDeclaration type (children 1)
    DataType Enum (children 1)
     ExpressionList (children 5)
      Function equals (children 1)
       ExpressionList (children 2)
        Literal \'terraced\'
        Literal UInt64_1
      Function equals (children 1)
       ExpressionList (children 2)
        Literal \'semi-detached\'
        Literal UInt64_2
      Function equals (children 1)
       ExpressionList (children 2)
        Literal \'detached\'
        Literal UInt64_3
      Function equals (children 1)
       ExpressionList (children 2)
        Literal \'flat\'
        Literal UInt64_4
      Function equals (children 1)
       ExpressionList (children 2)
        Literal \'other\'
        Literal UInt64_0
   ColumnDeclaration is_new (children 1)
    DataType UInt8
   ColumnDeclaration duration (children 1)
    DataType Enum (children 1)
     ExpressionList (children 3)
      Function equals (children 1)
       ExpressionList (children 2)
        Literal \'freehold\'
        Literal UInt64_1
      Function equals (children 1)
       ExpressionList (children 2)
        Literal \'leasehold\'
        Literal UInt64_2
      Function equals (children 1)
       ExpressionList (children 2)
        Literal \'unknown\'
        Literal UInt64_0
   ColumnDeclaration addr1 (children 1)
    DataType String
   ColumnDeclaration addr2 (children 1)
    DataType String
   ColumnDeclaration street (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
   ColumnDeclaration locality (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
   ColumnDeclaration town (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
   ColumnDeclaration district (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
   ColumnDeclaration county (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
  ExpressionList (children 1)
   Index (children 2)
    Identifier county
    Function set (children 1)
     ExpressionList (children 1)
      Literal UInt64_10
  ExpressionList (children 2)
   Projection (children 1)
    ProjectionSelectQuery (children 2)
     ExpressionList (children 3)
      Identifier town
      Identifier date
      Identifier price
     Function tuple (children 1)
      ExpressionList (children 2)
       Identifier town
       Identifier date
   Projection (children 1)
    ProjectionSelectQuery (children 2)
     ExpressionList (children 3)
      Function avg (children 1)
       ExpressionList (children 1)
        Identifier price
      Function max (children 1)
       ExpressionList (children 1)
        Identifier price
      Function sum (children 1)
       ExpressionList (children 1)
        Identifier price
     ExpressionList (children 1)
      Identifier town
 Storage definition (children 2)
  Function MergeTree
  Function tuple (children 1)
   ExpressionList (children 3)
    Identifier postcode1
    Identifier postcode2
    Identifier date
