pub const CREATE: &str = "-- Covers hash inner join and hash aggregation.\n\nCREATE MATERIALIZED VIEW nexmark_q4\nAS\nSELECT\n Q.category,\n AVG(Q.final) as avg\nFROM (\n SELECT\n MAX(B.price) AS final,A.category\n FROM\n auction A,\n bid B\n WHERE\n A.id = B.auction AND\n B.date_time BETWEEN A.date_time AND A.expires\n GROUP BY\n A.id,A.category\n ) Q\nGROUP BY\n Q.category;\n";