pub const CREATE: &str = "-- Covers hash inner join.\n\nCREATE MATERIALIZED VIEW nexmark_q3\nAS\nSELECT\n P.name, P.city, P.state, A.id\nFROM\n auction AS A INNER JOIN person AS P on A.seller = P.id\nWHERE\n A.category = 10 and (P.state = \'or\' OR P.state = \'id\' OR P.state = \'ca\');\n";