// Desc: Test the painter function use graphic_walker_parser::parser::model::Dataset; use test_utils::test_parser; mod test_utils; #[test] fn test_painter_empty() { let query = r#"{ "workflow": [ { "type": "transform", "transform": [ { "key": "gw_paint_fid", "expression": { "op": "paint", "as": "gw_paint_fid", "params": [ { "type": "map", "value": { "x": "math score", "y": "reading score", "domainX": [ 0, 100 ], "domainY": [ 17, 100 ], "map": "7cExAQAAAMKg9U9tDB+gAAAAAAAAAAAAAAAAAAAAgLcB", "dict": { "0": { "name": "L_1" } }, "mapwidth": 128 } } ] } } ] }, { "type": "view", "query": [ { "op": "aggregate", "groupBy": [ "gw_paint_fid", "gw_paint_fid" ], "measures": [ { "field": "math score", "agg": "sum", "asFieldKey": "math score_sum" } ] } ] } ] }"#; let dataset = Dataset::Table { name: "table_1".to_string(), }; let sql = "SELECT CASE WHEN \"math score\" BETWEEN 0 AND 100 AND \"reading score\" BETWEEN 17 AND 100 THEN 'L_1' END AS \"gw_paint_fid\", CASE WHEN \"math score\" BETWEEN 0 AND 100 AND \"reading score\" BETWEEN 17 AND 100 THEN 'L_1' END AS \"gw_paint_fid\", sum(\"math score\") AS \"math score_sum\" FROM \"table_1\" GROUP BY \"gw_paint_fid\", \"gw_paint_fid\""; let err = test_parser(query, sql, &dataset); assert!(err.is_none()); } #[test] fn test_column_painter() { let query = r#"{ "workflow":[ { "type": "transform", "transform": [ { "key": "gw_paint_fid", "expression": { "op": "paint", "as": "gw_paint_fid", "params": [ { "type": "map", "value": { "x": "reading score", "y": "math score", "domainX": [ 17, 100 ], "domainY": [ 0, 100 ], "map": "7drBCcAgEEVBt/+mQzrwlBfYeQ3MPwgieI4kSZIkSZIkSbpo3mK+GzDTDuDz+fzIHz5/7/Hn8/l8/na/vn/58QA+n8/n8/l8Pp/P5/O/8Jc+wPl/OYB8fjig4vMPUJIuewA=", "dict": { "0": { "name": "L_1" }, "1": { "name": "L_2" } }, "mapwidth": 128 } } ] } } ] }, { "type": "view", "query": [ { "op": "raw", "fields": [ "gw_paint_fid", "reading score", "math score" ] } ] } ] }"#; let dataset = Dataset::Table { name: "table_1".to_string(), }; let sql = "SELECT CASE WHEN \"reading score\" BETWEEN 17 AND 68.875 AND \"math score\" BETWEEN 0 AND 100 THEN 'L_1' WHEN \"reading score\" BETWEEN 68.875 AND 100 AND \"math score\" BETWEEN 0 AND 35.9375 THEN 'L_1' WHEN \"reading score\" BETWEEN 68.875 AND 70.171875 AND \"math score\" BETWEEN 35.9375 AND 37.5 THEN 'L_1' WHEN \"reading score\" BETWEEN 70.171875 AND 70.8203125 AND \"math score\" BETWEEN 35.9375 AND 36.71875 THEN 'L_1' WHEN \"reading score\" BETWEEN 70.8203125 AND 74.0625 AND \"math score\" BETWEEN 35.9375 AND 93.75 THEN 'L_2' WHEN \"reading score\" BETWEEN 74.0625 AND 100 AND \"math score\" BETWEEN 35.9375 AND 36.71875 THEN 'L_1' WHEN \"reading score\" BETWEEN 70.171875 AND 70.8203125 AND \"math score\" BETWEEN 36.71875 AND 92.96875 THEN 'L_2' WHEN \"reading score\" BETWEEN 74.0625 AND 74.7109375 AND \"math score\" BETWEEN 36.71875 AND 94.53125 THEN 'L_2' WHEN \"reading score\" BETWEEN 74.7109375 AND 100 AND \"math score\" BETWEEN 36.71875 AND 37.5 THEN 'L_1' WHEN \"reading score\" BETWEEN 68.875 AND 69.5234375 AND \"math score\" BETWEEN 37.5 AND 45.3125 THEN 'L_1' WHEN \"reading score\" BETWEEN 69.5234375 AND 70.171875 AND \"math score\" BETWEEN 37.5 AND 89.0625 THEN 'L_2' WHEN \"reading score\" BETWEEN 74.7109375 AND 75.359375 AND \"math score\" BETWEEN 37.5 AND 48.4375 THEN 'L_2' WHEN \"reading score\" BETWEEN 75.359375 AND 100 AND \"math score\" BETWEEN 37.5 AND 85.15625 THEN 'L_1' WHEN \"reading score\" BETWEEN 68.875 AND 69.5234375 AND \"math score\" BETWEEN 45.3125 AND 62.5 THEN 'L_2' WHEN \"reading score\" BETWEEN 74.7109375 AND 75.359375 AND \"math score\" BETWEEN 48.4375 AND 59.375 THEN 'L_1' WHEN \"reading score\" BETWEEN 74.7109375 AND 75.359375 AND \"math score\" BETWEEN 59.375 AND 93.75 THEN 'L_2' WHEN \"reading score\" BETWEEN 68.875 AND 69.5234375 AND \"math score\" BETWEEN 62.5 AND 100 THEN 'L_1' WHEN \"reading score\" BETWEEN 75.359375 AND 76.0078125 AND \"math score\" BETWEEN 85.15625 AND 92.96875 THEN 'L_2' WHEN \"reading score\" BETWEEN 76.0078125 AND 100 AND \"math score\" BETWEEN 85.15625 AND 100 THEN 'L_1' WHEN \"reading score\" BETWEEN 69.5234375 AND 70.171875 AND \"math score\" BETWEEN 89.0625 AND 100 THEN 'L_1' WHEN \"reading score\" BETWEEN 70.171875 AND 70.8203125 AND \"math score\" BETWEEN 92.96875 AND 100 THEN 'L_1' WHEN \"reading score\" BETWEEN 75.359375 AND 76.0078125 AND \"math score\" BETWEEN 92.96875 AND 100 THEN 'L_1' WHEN \"reading score\" BETWEEN 70.8203125 AND 71.46875 AND \"math score\" BETWEEN 93.75 AND 100 THEN 'L_1' WHEN \"reading score\" BETWEEN 71.46875 AND 74.0625 AND \"math score\" BETWEEN 93.75 AND 94.53125 THEN 'L_2' WHEN \"reading score\" BETWEEN 74.7109375 AND 75.359375 AND \"math score\" BETWEEN 93.75 AND 100 THEN 'L_1' WHEN \"reading score\" BETWEEN 71.46875 AND 74.7109375 AND \"math score\" BETWEEN 94.53125 AND 100 THEN 'L_1' END AS \"gw_paint_fid\", \"reading score\", \"math score\" FROM \"table_1\""; let err = test_parser(query, sql, &dataset); assert!(err.is_none()); } #[test] fn test_row_painter() { let query = r#"{ "workflow":[ { "type": "transform", "transform": [ { "key": "gw_paint_fid", "expression": { "op": "paint", "as": "gw_paint_fid", "params": [ { "type": "map", "value": { "x": "reading score", "y": "math score", "domainX": [ 17, 100 ], "domainY": [ 0, 100 ], "map": "7dPBCQAwCARB03/TqSEiHJiZBvYeWgUAAAAAAAAAAAAsdmaE890BY/nmAP2/++n7j/8/AAAAAPDqAg==", "dict": { "0": { "name": "L_1" }, "1": { "name": "L_2" } }, "mapwidth": 128 } } ] } } ] }, { "type": "view", "query": [ { "op": "raw", "fields": [ "gw_paint_fid", "reading score", "math score" ] } ] } ] }"#; let dataset = Dataset::Table { name: "table_1".to_string(), }; let sql = "SELECT CASE WHEN \"reading score\" BETWEEN 17 AND 100 AND \"math score\" BETWEEN 0 AND 62.5 THEN 'L_1' WHEN \"reading score\" BETWEEN 17 AND 43.5859375 AND \"math score\" BETWEEN 62.5 AND 100 THEN 'L_1' WHEN \"reading score\" BETWEEN 43.5859375 AND 44.8828125 AND \"math score\" BETWEEN 62.5 AND 63.28125 THEN 'L_1' WHEN \"reading score\" BETWEEN 44.8828125 AND 90.921875 AND \"math score\" BETWEEN 62.5 AND 69.53125 THEN 'L_2' WHEN \"reading score\" BETWEEN 90.921875 AND 100 AND \"math score\" BETWEEN 62.5 AND 63.28125 THEN 'L_1' WHEN \"reading score\" BETWEEN 43.5859375 AND 44.234375 AND \"math score\" BETWEEN 63.28125 AND 64.0625 THEN 'L_1' WHEN \"reading score\" BETWEEN 44.234375 AND 44.8828125 AND \"math score\" BETWEEN 63.28125 AND 68.75 THEN 'L_2' WHEN \"reading score\" BETWEEN 90.921875 AND 91.5703125 AND \"math score\" BETWEEN 63.28125 AND 68.75 THEN 'L_2' WHEN \"reading score\" BETWEEN 91.5703125 AND 100 AND \"math score\" BETWEEN 63.28125 AND 64.0625 THEN 'L_1' WHEN \"reading score\" BETWEEN 43.5859375 AND 44.234375 AND \"math score\" BETWEEN 64.0625 AND 67.96875 THEN 'L_2' WHEN \"reading score\" BETWEEN 91.5703125 AND 92.21875 AND \"math score\" BETWEEN 64.0625 AND 67.96875 THEN 'L_2' WHEN \"reading score\" BETWEEN 92.21875 AND 100 AND \"math score\" BETWEEN 64.0625 AND 100 THEN 'L_1' WHEN \"reading score\" BETWEEN 43.5859375 AND 44.234375 AND \"math score\" BETWEEN 67.96875 AND 100 THEN 'L_1' WHEN \"reading score\" BETWEEN 91.5703125 AND 92.21875 AND \"math score\" BETWEEN 67.96875 AND 100 THEN 'L_1' WHEN \"reading score\" BETWEEN 44.234375 AND 44.8828125 AND \"math score\" BETWEEN 68.75 AND 100 THEN 'L_1' WHEN \"reading score\" BETWEEN 90.921875 AND 91.5703125 AND \"math score\" BETWEEN 68.75 AND 100 THEN 'L_1' WHEN \"reading score\" BETWEEN 44.8828125 AND 90.921875 AND \"math score\" BETWEEN 69.53125 AND 100 THEN 'L_1' END AS \"gw_paint_fid\", \"reading score\", \"math score\" FROM \"table_1\""; let err = test_parser(query, sql, &dataset); assert!(err.is_none()); } #[test] fn test_painter() { let query = r#"{ "workflow":[ { "type": "transform", "transform": [ { "key": "gw_paint_fid", "expression": { "op": "paint", "as": "gw_paint_fid", "params": [ { "type": "map", "value": { "x": "math score", "y": "reading score", "domainX": [ 0, 100 ], "domainY": [ 17, 100 ], "map": "7drBcsMgDATQcOH//5hOcykGAQJ2JdxBVxu/BQKJmaS0Wh9IrbhAfslH1vl+eYuhL94Bnf6WP3UH2FcFJK4/U18yzP1CUfHMdeDgPyUFD/c/0rMNeSmAZffnfAIvBDD2ywDW/El+6vkkvhwAcz4n2z6RfwTw4N394S/CfuvwW0xfwe8F2PFDYAfoN6X7g6bOfmD7g5YYf33bB/nLG88x/h7f8PU8xZ/gGf641Tn+Jj9+Ke7zBF/RCMdv+tv8ef4MD/BXjtyQfOc8ZMhj/DyF6laKP1HH+D78Mb4zf/3rX/767/BRiRd92Iit8xB/o/vXf78ffP1VHu4vNfTzUTv2G/34LYi/zn8DePgx/gW4PojXPylS/PpS6/DAyG8enuQ8z2+e3kSk357+5vERx6+uKHzA/jfvP/lNv7P6Gn78n75wTQ5Q8Ht+d/MT/bL7fj6A73/3SAfIht2XBoDFe/vy9XoCSn7LH/H1AFTdN/MTnp/zE9wf88UAxMrf4bd8aPd7j8kC1LyB/5F8BK/93S0NgJOfgLOvf+2pA0C6r3/tIvnqf7qVPohvH9/Eop4B1OO2WiX/DODA537y8KPgs/gj/ToAjZf9KgDPVw0AkZcCPDYhui9VeAQgW2JlvgefD4AH7+4Hbz9c38JXfAC4/ngFkP1WOftG6+/6c/4P", "dict": { "0": { "name": "L_1" }, "1": { "name": "L_2" }, "6": { "name": "L_7" }, "255": { "name": "" } }, "mapwidth": 128 } } ] } } ] }, { "type": "view", "query": [ { "op": "raw", "fields": [ "gw_paint_fid", "reading score", "math score" ] } ] } ] }"#; let dataset = Dataset::Table { name: "table_1".to_string(), }; let sql = "SELECT CASE WHEN \"math score\" BETWEEN 0 AND 14.84375 AND \"reading score\" BETWEEN 17 AND 22.8359375 THEN '' WHEN \"math score\" BETWEEN 14.84375 AND 22.65625 AND \"reading score\" BETWEEN 17 AND 20.890625 THEN '' WHEN \"math score\" BETWEEN 22.65625 AND 26.5625 AND \"reading score\" BETWEEN 17 AND 20.2421875 THEN '' WHEN \"math score\" BETWEEN 26.5625 AND 39.0625 AND \"reading score\" BETWEEN 17 AND 19.59375 THEN '' WHEN \"math score\" BETWEEN 39.0625 AND 45.3125 AND \"reading score\" BETWEEN 17 AND 17.6484375 THEN '' WHEN \"math score\" BETWEEN 45.3125 AND 100 AND \"reading score\" BETWEEN 17 AND 32.5625 THEN 'L_1' WHEN \"math score\" BETWEEN 39.0625 AND 40.625 AND \"reading score\" BETWEEN 17.6484375 AND 20.2421875 THEN 'L_1' WHEN \"math score\" BETWEEN 40.625 AND 44.53125 AND \"reading score\" BETWEEN 17.6484375 AND 18.296875 THEN '' WHEN \"math score\" BETWEEN 44.53125 AND 45.3125 AND \"reading score\" BETWEEN 17.6484375 AND 21.5390625 THEN 'L_1' WHEN \"math score\" BETWEEN 40.625 AND 44.53125 AND \"reading score\" BETWEEN 18.296875 AND 20.2421875 THEN 'L_1' WHEN \"math score\" BETWEEN 26.5625 AND 27.34375 AND \"reading score\" BETWEEN 19.59375 AND 20.2421875 THEN 'L_1' WHEN \"math score\" BETWEEN 27.34375 AND 39.0625 AND \"reading score\" BETWEEN 19.59375 AND 33.2109375 THEN '' WHEN \"math score\" BETWEEN 22.65625 AND 25.78125 AND \"reading score\" BETWEEN 20.2421875 AND 23.484375 THEN 'L_1' WHEN \"math score\" BETWEEN 25.78125 AND 26.5625 AND \"reading score\" BETWEEN 20.2421875 AND 21.5390625 THEN 'L_1' WHEN \"math score\" BETWEEN 26.5625 AND 27.34375 AND \"reading score\" BETWEEN 20.2421875 AND 46.828125 THEN '' WHEN \"math score\" BETWEEN 39.0625 AND 39.84375 AND \"reading score\" BETWEEN 20.2421875 AND 20.890625 THEN 'L_1' WHEN \"math score\" BETWEEN 39.84375 AND 43.75 AND \"reading score\" BETWEEN 20.2421875 AND 28.0234375 THEN '' WHEN \"math score\" BETWEEN 43.75 AND 44.53125 AND \"reading score\" BETWEEN 20.2421875 AND 20.890625 THEN 'L_1' WHEN \"math score\" BETWEEN 14.84375 AND 17.96875 AND \"reading score\" BETWEEN 20.890625 AND 21.5390625 THEN '' WHEN \"math score\" BETWEEN 17.96875 AND 22.65625 AND \"reading score\" BETWEEN 20.890625 AND 27.375 THEN 'L_1' WHEN \"math score\" BETWEEN 39.0625 AND 39.84375 AND \"reading score\" BETWEEN 20.890625 AND 32.5625 THEN '' WHEN \"math score\" BETWEEN 43.75 AND 44.53125 AND \"reading score\" BETWEEN 20.890625 AND 26.7265625 THEN '' WHEN \"math score\" BETWEEN 14.84375 AND 17.96875 AND \"reading score\" BETWEEN 21.5390625 AND 22.8359375 THEN 'L_1' WHEN \"math score\" BETWEEN 25.78125 AND 26.5625 AND \"reading score\" BETWEEN 21.5390625 AND 46.828125 THEN '' WHEN \"math score\" BETWEEN 44.53125 AND 45.3125 AND \"reading score\" BETWEEN 21.5390625 AND 25.4296875 THEN '' WHEN \"math score\" BETWEEN 0 AND 3.90625 AND \"reading score\" BETWEEN 22.8359375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 3.90625 AND 15.625 AND \"reading score\" BETWEEN 22.8359375 AND 23.484375 THEN '' WHEN \"math score\" BETWEEN 15.625 AND 17.96875 AND \"reading score\" BETWEEN 22.8359375 AND 24.1328125 THEN 'L_1' WHEN \"math score\" BETWEEN 3.90625 AND 5.46875 AND \"reading score\" BETWEEN 23.484375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 5.46875 AND 15.625 AND \"reading score\" BETWEEN 23.484375 AND 24.1328125 THEN '' WHEN \"math score\" BETWEEN 22.65625 AND 25 AND \"reading score\" BETWEEN 23.484375 AND 24.78125 THEN 'L_1' WHEN \"math score\" BETWEEN 25 AND 25.78125 AND \"reading score\" BETWEEN 23.484375 AND 46.828125 THEN '' WHEN \"math score\" BETWEEN 5.46875 AND 6.25 AND \"reading score\" BETWEEN 24.1328125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 6.25 AND 16.40625 AND \"reading score\" BETWEEN 24.1328125 AND 24.78125 THEN '' WHEN \"math score\" BETWEEN 16.40625 AND 17.96875 AND \"reading score\" BETWEEN 24.1328125 AND 24.78125 THEN 'L_1' WHEN \"math score\" BETWEEN 6.25 AND 7.8125 AND \"reading score\" BETWEEN 24.78125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 7.8125 AND 17.1875 AND \"reading score\" BETWEEN 24.78125 AND 25.4296875 THEN '' WHEN \"math score\" BETWEEN 17.1875 AND 17.96875 AND \"reading score\" BETWEEN 24.78125 AND 26.078125 THEN 'L_1' WHEN \"math score\" BETWEEN 22.65625 AND 24.21875 AND \"reading score\" BETWEEN 24.78125 AND 26.078125 THEN 'L_1' WHEN \"math score\" BETWEEN 24.21875 AND 25 AND \"reading score\" BETWEEN 24.78125 AND 46.828125 THEN '' WHEN \"math score\" BETWEEN 7.8125 AND 8.59375 AND \"reading score\" BETWEEN 25.4296875 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 8.59375 AND 17.1875 AND \"reading score\" BETWEEN 25.4296875 AND 26.078125 THEN '' WHEN \"math score\" BETWEEN 44.53125 AND 45.3125 AND \"reading score\" BETWEEN 25.4296875 AND 78.6015625 THEN 'L_1' WHEN \"math score\" BETWEEN 8.59375 AND 9.375 AND \"reading score\" BETWEEN 26.078125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 9.375 AND 17.96875 AND \"reading score\" BETWEEN 26.078125 AND 27.375 THEN '' WHEN \"math score\" BETWEEN 22.65625 AND 23.4375 AND \"reading score\" BETWEEN 26.078125 AND 28.0234375 THEN 'L_1' WHEN \"math score\" BETWEEN 23.4375 AND 24.21875 AND \"reading score\" BETWEEN 26.078125 AND 46.828125 THEN '' WHEN \"math score\" BETWEEN 43.75 AND 44.53125 AND \"reading score\" BETWEEN 26.7265625 AND 79.8984375 THEN 'L_1' WHEN \"math score\" BETWEEN 9.375 AND 10.15625 AND \"reading score\" BETWEEN 27.375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 10.15625 AND 18.75 AND \"reading score\" BETWEEN 27.375 AND 28.0234375 THEN '' WHEN \"math score\" BETWEEN 18.75 AND 22.65625 AND \"reading score\" BETWEEN 27.375 AND 28.0234375 THEN 'L_1' WHEN \"math score\" BETWEEN 10.15625 AND 10.9375 AND \"reading score\" BETWEEN 28.0234375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 10.9375 AND 19.53125 AND \"reading score\" BETWEEN 28.0234375 AND 29.96875 THEN '' WHEN \"math score\" BETWEEN 19.53125 AND 22.65625 AND \"reading score\" BETWEEN 28.0234375 AND 29.3203125 THEN 'L_1' WHEN \"math score\" BETWEEN 22.65625 AND 23.4375 AND \"reading score\" BETWEEN 28.0234375 AND 46.828125 THEN '' WHEN \"math score\" BETWEEN 39.84375 AND 42.1875 AND \"reading score\" BETWEEN 28.0234375 AND 29.96875 THEN '' WHEN \"math score\" BETWEEN 42.1875 AND 42.96875 AND \"reading score\" BETWEEN 28.0234375 AND 29.3203125 THEN '' WHEN \"math score\" BETWEEN 42.96875 AND 43.75 AND \"reading score\" BETWEEN 28.0234375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 19.53125 AND 20.3125 AND \"reading score\" BETWEEN 29.3203125 AND 46.1796875 THEN '' WHEN \"math score\" BETWEEN 20.3125 AND 22.65625 AND \"reading score\" BETWEEN 29.3203125 AND 31.265625 THEN 'L_1' WHEN \"math score\" BETWEEN 42.1875 AND 42.96875 AND \"reading score\" BETWEEN 29.3203125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 10.9375 AND 11.71875 AND \"reading score\" BETWEEN 29.96875 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 11.71875 AND 19.53125 AND \"reading score\" BETWEEN 29.96875 AND 30.6171875 THEN '' WHEN \"math score\" BETWEEN 39.84375 AND 41.40625 AND \"reading score\" BETWEEN 29.96875 AND 30.6171875 THEN '' WHEN \"math score\" BETWEEN 41.40625 AND 42.1875 AND \"reading score\" BETWEEN 29.96875 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 11.71875 AND 12.5 AND \"reading score\" BETWEEN 30.6171875 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 12.5 AND 19.53125 AND \"reading score\" BETWEEN 30.6171875 AND 31.265625 THEN '' WHEN \"math score\" BETWEEN 39.84375 AND 40.625 AND \"reading score\" BETWEEN 30.6171875 AND 31.265625 THEN '' WHEN \"math score\" BETWEEN 40.625 AND 41.40625 AND \"reading score\" BETWEEN 30.6171875 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 12.5 AND 13.28125 AND \"reading score\" BETWEEN 31.265625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 13.28125 AND 19.53125 AND \"reading score\" BETWEEN 31.265625 AND 32.5625 THEN '' WHEN \"math score\" BETWEEN 20.3125 AND 21.09375 AND \"reading score\" BETWEEN 31.265625 AND 46.1796875 THEN '' WHEN \"math score\" BETWEEN 21.09375 AND 21.875 AND \"reading score\" BETWEEN 31.265625 AND 32.5625 THEN 'L_1' WHEN \"math score\" BETWEEN 21.875 AND 22.65625 AND \"reading score\" BETWEEN 31.265625 AND 46.1796875 THEN '' WHEN \"math score\" BETWEEN 39.84375 AND 40.625 AND \"reading score\" BETWEEN 31.265625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 13.28125 AND 14.0625 AND \"reading score\" BETWEEN 32.5625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 14.0625 AND 19.53125 AND \"reading score\" BETWEEN 32.5625 AND 34.5078125 THEN '' WHEN \"math score\" BETWEEN 21.09375 AND 21.875 AND \"reading score\" BETWEEN 32.5625 AND 46.1796875 THEN '' WHEN \"math score\" BETWEEN 39.0625 AND 39.84375 AND \"reading score\" BETWEEN 32.5625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 45.3125 AND 57.8125 AND \"reading score\" BETWEEN 32.5625 AND 44.234375 THEN 'L_1' WHEN \"math score\" BETWEEN 57.8125 AND 60.9375 AND \"reading score\" BETWEEN 32.5625 AND 35.8046875 THEN 'L_1' WHEN \"math score\" BETWEEN 60.9375 AND 62.5 AND \"reading score\" BETWEEN 32.5625 AND 33.2109375 THEN 'L_1' WHEN \"math score\" BETWEEN 62.5 AND 66.40625 AND \"reading score\" BETWEEN 32.5625 AND 42.2890625 THEN 'L_2' WHEN \"math score\" BETWEEN 66.40625 AND 100 AND \"reading score\" BETWEEN 32.5625 AND 33.2109375 THEN 'L_1' WHEN \"math score\" BETWEEN 27.34375 AND 34.375 AND \"reading score\" BETWEEN 33.2109375 AND 39.046875 THEN '' WHEN \"math score\" BETWEEN 34.375 AND 37.5 AND \"reading score\" BETWEEN 33.2109375 AND 35.15625 THEN '' WHEN \"math score\" BETWEEN 37.5 AND 38.28125 AND \"reading score\" BETWEEN 33.2109375 AND 34.5078125 THEN '' WHEN \"math score\" BETWEEN 38.28125 AND 39.0625 AND \"reading score\" BETWEEN 33.2109375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 60.9375 AND 61.71875 AND \"reading score\" BETWEEN 33.2109375 AND 33.859375 THEN 'L_1' WHEN \"math score\" BETWEEN 61.71875 AND 62.5 AND \"reading score\" BETWEEN 33.2109375 AND 52.6640625 THEN 'L_2' WHEN \"math score\" BETWEEN 66.40625 AND 67.1875 AND \"reading score\" BETWEEN 33.2109375 AND 40.9921875 THEN 'L_2' WHEN \"math score\" BETWEEN 67.1875 AND 100 AND \"reading score\" BETWEEN 33.2109375 AND 33.859375 THEN 'L_1' WHEN \"math score\" BETWEEN 60.9375 AND 61.71875 AND \"reading score\" BETWEEN 33.859375 AND 53.3125 THEN 'L_2' WHEN \"math score\" BETWEEN 67.1875 AND 67.96875 AND \"reading score\" BETWEEN 33.859375 AND 38.3984375 THEN 'L_2' WHEN \"math score\" BETWEEN 67.96875 AND 96.09375 AND \"reading score\" BETWEEN 33.859375 AND 61.7421875 THEN 'L_1' WHEN \"math score\" BETWEEN 96.09375 AND 100 AND \"reading score\" BETWEEN 33.859375 AND 55.2578125 THEN 'L_1' WHEN \"math score\" BETWEEN 14.0625 AND 14.84375 AND \"reading score\" BETWEEN 34.5078125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 14.84375 AND 19.53125 AND \"reading score\" BETWEEN 34.5078125 AND 37.1015625 THEN '' WHEN \"math score\" BETWEEN 37.5 AND 38.28125 AND \"reading score\" BETWEEN 34.5078125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 34.375 AND 36.71875 AND \"reading score\" BETWEEN 35.15625 AND 36.453125 THEN '' WHEN \"math score\" BETWEEN 36.71875 AND 37.5 AND \"reading score\" BETWEEN 35.15625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 57.8125 AND 60.15625 AND \"reading score\" BETWEEN 35.8046875 AND 39.046875 THEN 'L_1' WHEN \"math score\" BETWEEN 60.15625 AND 60.9375 AND \"reading score\" BETWEEN 35.8046875 AND 56.5546875 THEN 'L_2' WHEN \"math score\" BETWEEN 34.375 AND 35.9375 AND \"reading score\" BETWEEN 36.453125 AND 37.1015625 THEN '' WHEN \"math score\" BETWEEN 35.9375 AND 36.71875 AND \"reading score\" BETWEEN 36.453125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 14.84375 AND 15.625 AND \"reading score\" BETWEEN 37.1015625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 15.625 AND 19.53125 AND \"reading score\" BETWEEN 37.1015625 AND 37.75 THEN '' WHEN \"math score\" BETWEEN 34.375 AND 35.15625 AND \"reading score\" BETWEEN 37.1015625 AND 37.75 THEN '' WHEN \"math score\" BETWEEN 35.15625 AND 35.9375 AND \"reading score\" BETWEEN 37.1015625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 15.625 AND 16.40625 AND \"reading score\" BETWEEN 37.75 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 16.40625 AND 19.53125 AND \"reading score\" BETWEEN 37.75 AND 44.8828125 THEN '' WHEN \"math score\" BETWEEN 34.375 AND 35.15625 AND \"reading score\" BETWEEN 37.75 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 67.1875 AND 67.96875 AND \"reading score\" BETWEEN 38.3984375 AND 84.4375 THEN 'L_1' WHEN \"math score\" BETWEEN 27.34375 AND 31.25 AND \"reading score\" BETWEEN 39.046875 AND 42.2890625 THEN '' WHEN \"math score\" BETWEEN 31.25 AND 32.8125 AND \"reading score\" BETWEEN 39.046875 AND 40.34375 THEN '' WHEN \"math score\" BETWEEN 32.8125 AND 33.59375 AND \"reading score\" BETWEEN 39.046875 AND 39.6953125 THEN '' WHEN \"math score\" BETWEEN 33.59375 AND 34.375 AND \"reading score\" BETWEEN 39.046875 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 57.8125 AND 59.375 AND \"reading score\" BETWEEN 39.046875 AND 39.6953125 THEN 'L_1' WHEN \"math score\" BETWEEN 59.375 AND 60.15625 AND \"reading score\" BETWEEN 39.046875 AND 60.4453125 THEN 'L_2' WHEN \"math score\" BETWEEN 32.8125 AND 33.59375 AND \"reading score\" BETWEEN 39.6953125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 57.8125 AND 58.59375 AND \"reading score\" BETWEEN 39.6953125 AND 41.640625 THEN 'L_1' WHEN \"math score\" BETWEEN 58.59375 AND 59.375 AND \"reading score\" BETWEEN 39.6953125 AND 61.09375 THEN 'L_2' WHEN \"math score\" BETWEEN 31.25 AND 32.03125 AND \"reading score\" BETWEEN 40.34375 AND 41.640625 THEN '' WHEN \"math score\" BETWEEN 32.03125 AND 32.8125 AND \"reading score\" BETWEEN 40.34375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 66.40625 AND 67.1875 AND \"reading score\" BETWEEN 40.9921875 AND 84.4375 THEN 'L_1' WHEN \"math score\" BETWEEN 31.25 AND 32.03125 AND \"reading score\" BETWEEN 41.640625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 57.8125 AND 58.59375 AND \"reading score\" BETWEEN 41.640625 AND 63.6875 THEN 'L_2' WHEN \"math score\" BETWEEN 27.34375 AND 30.46875 AND \"reading score\" BETWEEN 42.2890625 AND 44.234375 THEN '' WHEN \"math score\" BETWEEN 30.46875 AND 31.25 AND \"reading score\" BETWEEN 42.2890625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 62.5 AND 64.84375 AND \"reading score\" BETWEEN 42.2890625 AND 44.8828125 THEN 'L_2' WHEN \"math score\" BETWEEN 64.84375 AND 65.625 AND \"reading score\" BETWEEN 42.2890625 AND 42.9375 THEN 'L_2' WHEN \"math score\" BETWEEN 65.625 AND 66.40625 AND \"reading score\" BETWEEN 42.2890625 AND 84.4375 THEN 'L_1' WHEN \"math score\" BETWEEN 64.84375 AND 65.625 AND \"reading score\" BETWEEN 42.9375 AND 84.4375 THEN 'L_1' WHEN \"math score\" BETWEEN 27.34375 AND 28.90625 AND \"reading score\" BETWEEN 44.234375 AND 45.53125 THEN '' WHEN \"math score\" BETWEEN 28.90625 AND 29.6875 AND \"reading score\" BETWEEN 44.234375 AND 44.8828125 THEN '' WHEN \"math score\" BETWEEN 29.6875 AND 30.46875 AND \"reading score\" BETWEEN 44.234375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 45.3125 AND 55.46875 AND \"reading score\" BETWEEN 44.234375 AND 52.6640625 THEN 'L_1' WHEN \"math score\" BETWEEN 55.46875 AND 57.03125 AND \"reading score\" BETWEEN 44.234375 AND 45.53125 THEN 'L_1' WHEN \"math score\" BETWEEN 57.03125 AND 57.8125 AND \"reading score\" BETWEEN 44.234375 AND 66.9296875 THEN 'L_2' WHEN \"math score\" BETWEEN 16.40625 AND 17.1875 AND \"reading score\" BETWEEN 44.8828125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 17.1875 AND 19.53125 AND \"reading score\" BETWEEN 44.8828125 AND 45.53125 THEN '' WHEN \"math score\" BETWEEN 28.90625 AND 29.6875 AND \"reading score\" BETWEEN 44.8828125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 62.5 AND 64.0625 AND \"reading score\" BETWEEN 44.8828125 AND 47.4765625 THEN 'L_2' WHEN \"math score\" BETWEEN 64.0625 AND 64.84375 AND \"reading score\" BETWEEN 44.8828125 AND 84.4375 THEN 'L_1' WHEN \"math score\" BETWEEN 17.1875 AND 17.96875 AND \"reading score\" BETWEEN 45.53125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 17.96875 AND 19.53125 AND \"reading score\" BETWEEN 45.53125 AND 46.1796875 THEN '' WHEN \"math score\" BETWEEN 27.34375 AND 28.125 AND \"reading score\" BETWEEN 45.53125 AND 46.1796875 THEN '' WHEN \"math score\" BETWEEN 28.125 AND 28.90625 AND \"reading score\" BETWEEN 45.53125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 55.46875 AND 56.25 AND \"reading score\" BETWEEN 45.53125 AND 49.421875 THEN 'L_1' WHEN \"math score\" BETWEEN 56.25 AND 57.03125 AND \"reading score\" BETWEEN 45.53125 AND 69.5234375 THEN 'L_2' WHEN \"math score\" BETWEEN 17.96875 AND 22.65625 AND \"reading score\" BETWEEN 46.1796875 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 27.34375 AND 28.125 AND \"reading score\" BETWEEN 46.1796875 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 22.65625 AND 27.34375 AND \"reading score\" BETWEEN 46.828125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 62.5 AND 63.28125 AND \"reading score\" BETWEEN 47.4765625 AND 48.7734375 THEN 'L_2' WHEN \"math score\" BETWEEN 63.28125 AND 64.0625 AND \"reading score\" BETWEEN 47.4765625 AND 85.0859375 THEN 'L_1' WHEN \"math score\" BETWEEN 62.5 AND 63.28125 AND \"reading score\" BETWEEN 48.7734375 AND 85.734375 THEN 'L_1' WHEN \"math score\" BETWEEN 55.46875 AND 56.25 AND \"reading score\" BETWEEN 49.421875 AND 72.1171875 THEN 'L_2' WHEN \"math score\" BETWEEN 45.3125 AND 53.125 AND \"reading score\" BETWEEN 52.6640625 AND 59.796875 THEN 'L_1' WHEN \"math score\" BETWEEN 53.125 AND 54.6875 AND \"reading score\" BETWEEN 52.6640625 AND 53.3125 THEN 'L_1' WHEN \"math score\" BETWEEN 54.6875 AND 55.46875 AND \"reading score\" BETWEEN 52.6640625 AND 74.0625 THEN 'L_2' WHEN \"math score\" BETWEEN 61.71875 AND 62.5 AND \"reading score\" BETWEEN 52.6640625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 53.125 AND 53.90625 AND \"reading score\" BETWEEN 53.3125 AND 57.203125 THEN 'L_1' WHEN \"math score\" BETWEEN 53.90625 AND 54.6875 AND \"reading score\" BETWEEN 53.3125 AND 76.0078125 THEN 'L_2' WHEN \"math score\" BETWEEN 60.9375 AND 61.71875 AND \"reading score\" BETWEEN 53.3125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 96.09375 AND 97.65625 AND \"reading score\" BETWEEN 55.2578125 AND 55.90625 THEN 'L_1' WHEN \"math score\" BETWEEN 97.65625 AND 100 AND \"reading score\" BETWEEN 55.2578125 AND 64.3359375 THEN 'L_2' WHEN \"math score\" BETWEEN 96.09375 AND 96.875 AND \"reading score\" BETWEEN 55.90625 AND 56.5546875 THEN 'L_1' WHEN \"math score\" BETWEEN 96.875 AND 97.65625 AND \"reading score\" BETWEEN 55.90625 AND 63.6875 THEN 'L_2' WHEN \"math score\" BETWEEN 60.15625 AND 60.9375 AND \"reading score\" BETWEEN 56.5546875 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 96.09375 AND 96.875 AND \"reading score\" BETWEEN 56.5546875 AND 63.0390625 THEN 'L_2' WHEN \"math score\" BETWEEN 53.125 AND 53.90625 AND \"reading score\" BETWEEN 57.203125 AND 76.65625 THEN 'L_2' WHEN \"math score\" BETWEEN 45.3125 AND 50.78125 AND \"reading score\" BETWEEN 59.796875 AND 66.28125 THEN 'L_1' WHEN \"math score\" BETWEEN 50.78125 AND 52.34375 AND \"reading score\" BETWEEN 59.796875 AND 60.4453125 THEN 'L_1' WHEN \"math score\" BETWEEN 52.34375 AND 53.125 AND \"reading score\" BETWEEN 59.796875 AND 78.6015625 THEN 'L_2' WHEN \"math score\" BETWEEN 50.78125 AND 51.5625 AND \"reading score\" BETWEEN 60.4453125 AND 63.6875 THEN 'L_1' WHEN \"math score\" BETWEEN 51.5625 AND 52.34375 AND \"reading score\" BETWEEN 60.4453125 AND 81.1953125 THEN 'L_2' WHEN \"math score\" BETWEEN 59.375 AND 60.15625 AND \"reading score\" BETWEEN 60.4453125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 58.59375 AND 59.375 AND \"reading score\" BETWEEN 61.09375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 67.96875 AND 89.84375 AND \"reading score\" BETWEEN 61.7421875 AND 66.9296875 THEN 'L_1' WHEN \"math score\" BETWEEN 89.84375 AND 92.1875 AND \"reading score\" BETWEEN 61.7421875 AND 63.6875 THEN 'L_1' WHEN \"math score\" BETWEEN 92.1875 AND 95.3125 AND \"reading score\" BETWEEN 61.7421875 AND 63.0390625 THEN 'L_1' WHEN \"math score\" BETWEEN 95.3125 AND 96.09375 AND \"reading score\" BETWEEN 61.7421875 AND 63.0390625 THEN 'L_2' WHEN \"math score\" BETWEEN 92.1875 AND 96.875 AND \"reading score\" BETWEEN 63.0390625 AND 70.171875 THEN 'L_7' WHEN \"math score\" BETWEEN 50.78125 AND 51.5625 AND \"reading score\" BETWEEN 63.6875 AND 82.4921875 THEN 'L_2' WHEN \"math score\" BETWEEN 57.8125 AND 58.59375 AND \"reading score\" BETWEEN 63.6875 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 89.84375 AND 91.40625 AND \"reading score\" BETWEEN 63.6875 AND 64.3359375 THEN 'L_1' WHEN \"math score\" BETWEEN 91.40625 AND 92.1875 AND \"reading score\" BETWEEN 63.6875 AND 79.25 THEN 'L_7' WHEN \"math score\" BETWEEN 96.875 AND 97.65625 AND \"reading score\" BETWEEN 63.6875 AND 69.5234375 THEN 'L_7' WHEN \"math score\" BETWEEN 89.84375 AND 90.625 AND \"reading score\" BETWEEN 64.3359375 AND 66.28125 THEN 'L_1' WHEN \"math score\" BETWEEN 90.625 AND 91.40625 AND \"reading score\" BETWEEN 64.3359375 AND 79.8984375 THEN 'L_7' WHEN \"math score\" BETWEEN 97.65625 AND 98.4375 AND \"reading score\" BETWEEN 64.3359375 AND 67.578125 THEN 'L_7' WHEN \"math score\" BETWEEN 98.4375 AND 100 AND \"reading score\" BETWEEN 64.3359375 AND 73.4140625 THEN 'L_2' WHEN \"math score\" BETWEEN 45.3125 AND 49.21875 AND \"reading score\" BETWEEN 66.28125 AND 70.8203125 THEN 'L_1' WHEN \"math score\" BETWEEN 49.21875 AND 50 AND \"reading score\" BETWEEN 66.28125 AND 68.875 THEN 'L_1' WHEN \"math score\" BETWEEN 50 AND 50.78125 AND \"reading score\" BETWEEN 66.28125 AND 83.7890625 THEN 'L_2' WHEN \"math score\" BETWEEN 89.84375 AND 90.625 AND \"reading score\" BETWEEN 66.28125 AND 80.546875 THEN 'L_7' WHEN \"math score\" BETWEEN 57.03125 AND 57.8125 AND \"reading score\" BETWEEN 66.9296875 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 67.96875 AND 70.3125 AND \"reading score\" BETWEEN 66.9296875 AND 68.2265625 THEN 'L_1' WHEN \"math score\" BETWEEN 70.3125 AND 71.09375 AND \"reading score\" BETWEEN 66.9296875 AND 67.578125 THEN 'L_1' WHEN \"math score\" BETWEEN 71.09375 AND 75 AND \"reading score\" BETWEEN 66.9296875 AND 76.65625 THEN '' WHEN \"math score\" BETWEEN 75 AND 89.84375 AND \"reading score\" BETWEEN 66.9296875 AND 67.578125 THEN 'L_1' WHEN \"math score\" BETWEEN 70.3125 AND 71.09375 AND \"reading score\" BETWEEN 67.578125 AND 74.7109375 THEN '' WHEN \"math score\" BETWEEN 75 AND 75.78125 AND \"reading score\" BETWEEN 67.578125 AND 83.140625 THEN '' WHEN \"math score\" BETWEEN 75.78125 AND 89.84375 AND \"reading score\" BETWEEN 67.578125 AND 68.2265625 THEN 'L_1' WHEN \"math score\" BETWEEN 97.65625 AND 98.4375 AND \"reading score\" BETWEEN 67.578125 AND 77.3046875 THEN 'L_2' WHEN \"math score\" BETWEEN 67.96875 AND 69.53125 AND \"reading score\" BETWEEN 68.2265625 AND 84.4375 THEN 'L_1' WHEN \"math score\" BETWEEN 69.53125 AND 70.3125 AND \"reading score\" BETWEEN 68.2265625 AND 72.1171875 THEN '' WHEN \"math score\" BETWEEN 75.78125 AND 76.5625 AND \"reading score\" BETWEEN 68.2265625 AND 84.4375 THEN '' WHEN \"math score\" BETWEEN 76.5625 AND 89.0625 AND \"reading score\" BETWEEN 68.2265625 AND 68.875 THEN 'L_1' WHEN \"math score\" BETWEEN 89.0625 AND 89.84375 AND \"reading score\" BETWEEN 68.2265625 AND 82.4921875 THEN 'L_7' WHEN \"math score\" BETWEEN 49.21875 AND 50 AND \"reading score\" BETWEEN 68.875 AND 84.4375 THEN 'L_2' WHEN \"math score\" BETWEEN 76.5625 AND 77.34375 AND \"reading score\" BETWEEN 68.875 AND 85.0859375 THEN '' WHEN \"math score\" BETWEEN 77.34375 AND 87.5 AND \"reading score\" BETWEEN 68.875 AND 72.1171875 THEN 'L_1' WHEN \"math score\" BETWEEN 87.5 AND 89.0625 AND \"reading score\" BETWEEN 68.875 AND 70.171875 THEN 'L_1' WHEN \"math score\" BETWEEN 56.25 AND 57.03125 AND \"reading score\" BETWEEN 69.5234375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 96.875 AND 97.65625 AND \"reading score\" BETWEEN 69.5234375 AND 78.6015625 THEN 'L_2' WHEN \"math score\" BETWEEN 87.5 AND 88.28125 AND \"reading score\" BETWEEN 70.171875 AND 70.8203125 THEN 'L_1' WHEN \"math score\" BETWEEN 88.28125 AND 89.0625 AND \"reading score\" BETWEEN 70.171875 AND 83.7890625 THEN 'L_7' WHEN \"math score\" BETWEEN 92.1875 AND 95.3125 AND \"reading score\" BETWEEN 70.171875 AND 73.4140625 THEN 'L_7' WHEN \"math score\" BETWEEN 95.3125 AND 96.09375 AND \"reading score\" BETWEEN 70.171875 AND 72.1171875 THEN 'L_7' WHEN \"math score\" BETWEEN 96.09375 AND 96.875 AND \"reading score\" BETWEEN 70.171875 AND 80.546875 THEN 'L_2' WHEN \"math score\" BETWEEN 45.3125 AND 48.4375 AND \"reading score\" BETWEEN 70.8203125 AND 72.765625 THEN 'L_1' WHEN \"math score\" BETWEEN 48.4375 AND 49.21875 AND \"reading score\" BETWEEN 70.8203125 AND 85.0859375 THEN 'L_2' WHEN \"math score\" BETWEEN 87.5 AND 88.28125 AND \"reading score\" BETWEEN 70.8203125 AND 84.4375 THEN 'L_7' WHEN \"math score\" BETWEEN 55.46875 AND 56.25 AND \"reading score\" BETWEEN 72.1171875 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 69.53125 AND 70.3125 AND \"reading score\" BETWEEN 72.1171875 AND 84.4375 THEN 'L_1' WHEN \"math score\" BETWEEN 77.34375 AND 78.125 AND \"reading score\" BETWEEN 72.1171875 AND 86.3828125 THEN '' WHEN \"math score\" BETWEEN 78.125 AND 86.71875 AND \"reading score\" BETWEEN 72.1171875 AND 74.0625 THEN 'L_1' WHEN \"math score\" BETWEEN 86.71875 AND 87.5 AND \"reading score\" BETWEEN 72.1171875 AND 72.765625 THEN 'L_1' WHEN \"math score\" BETWEEN 95.3125 AND 96.09375 AND \"reading score\" BETWEEN 72.1171875 AND 81.84375 THEN 'L_2' WHEN \"math score\" BETWEEN 45.3125 AND 47.65625 AND \"reading score\" BETWEEN 72.765625 AND 74.7109375 THEN 'L_1' WHEN \"math score\" BETWEEN 47.65625 AND 48.4375 AND \"reading score\" BETWEEN 72.765625 AND 85.0859375 THEN 'L_2' WHEN \"math score\" BETWEEN 86.71875 AND 87.5 AND \"reading score\" BETWEEN 72.765625 AND 85.0859375 THEN 'L_7' WHEN \"math score\" BETWEEN 92.1875 AND 94.53125 AND \"reading score\" BETWEEN 73.4140625 AND 74.7109375 THEN 'L_7' WHEN \"math score\" BETWEEN 94.53125 AND 95.3125 AND \"reading score\" BETWEEN 73.4140625 AND 83.7890625 THEN 'L_2' WHEN \"math score\" BETWEEN 98.4375 AND 99.21875 AND \"reading score\" BETWEEN 73.4140625 AND 74.7109375 THEN 'L_2' WHEN \"math score\" BETWEEN 99.21875 AND 100 AND \"reading score\" BETWEEN 73.4140625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 54.6875 AND 55.46875 AND \"reading score\" BETWEEN 74.0625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 78.125 AND 78.90625 AND \"reading score\" BETWEEN 74.0625 AND 87.6796875 THEN '' WHEN \"math score\" BETWEEN 78.90625 AND 85.15625 AND \"reading score\" BETWEEN 74.0625 AND 76.0078125 THEN 'L_1' WHEN \"math score\" BETWEEN 85.15625 AND 85.9375 AND \"reading score\" BETWEEN 74.0625 AND 74.7109375 THEN 'L_1' WHEN \"math score\" BETWEEN 85.9375 AND 86.71875 AND \"reading score\" BETWEEN 74.0625 AND 85.734375 THEN 'L_7' WHEN \"math score\" BETWEEN 45.3125 AND 46.875 AND \"reading score\" BETWEEN 74.7109375 AND 75.359375 THEN 'L_1' WHEN \"math score\" BETWEEN 46.875 AND 47.65625 AND \"reading score\" BETWEEN 74.7109375 AND 85.0859375 THEN 'L_2' WHEN \"math score\" BETWEEN 70.3125 AND 71.09375 AND \"reading score\" BETWEEN 74.7109375 AND 84.4375 THEN 'L_1' WHEN \"math score\" BETWEEN 85.15625 AND 85.9375 AND \"reading score\" BETWEEN 74.7109375 AND 85.0859375 THEN 'L_7' WHEN \"math score\" BETWEEN 92.1875 AND 93.75 AND \"reading score\" BETWEEN 74.7109375 AND 76.0078125 THEN 'L_7' WHEN \"math score\" BETWEEN 93.75 AND 94.53125 AND \"reading score\" BETWEEN 74.7109375 AND 85.0859375 THEN 'L_2' WHEN \"math score\" BETWEEN 98.4375 AND 99.21875 AND \"reading score\" BETWEEN 74.7109375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 45.3125 AND 46.09375 AND \"reading score\" BETWEEN 75.359375 AND 76.65625 THEN 'L_1' WHEN \"math score\" BETWEEN 46.09375 AND 46.875 AND \"reading score\" BETWEEN 75.359375 AND 85.0859375 THEN 'L_2' WHEN \"math score\" BETWEEN 53.90625 AND 54.6875 AND \"reading score\" BETWEEN 76.0078125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 78.90625 AND 79.6875 AND \"reading score\" BETWEEN 76.0078125 AND 88.328125 THEN '' WHEN \"math score\" BETWEEN 79.6875 AND 84.375 AND \"reading score\" BETWEEN 76.0078125 AND 77.3046875 THEN 'L_1' WHEN \"math score\" BETWEEN 84.375 AND 85.15625 AND \"reading score\" BETWEEN 76.0078125 AND 76.65625 THEN 'L_1' WHEN \"math score\" BETWEEN 92.1875 AND 92.96875 AND \"reading score\" BETWEEN 76.0078125 AND 77.3046875 THEN 'L_7' WHEN \"math score\" BETWEEN 92.96875 AND 93.75 AND \"reading score\" BETWEEN 76.0078125 AND 86.3828125 THEN 'L_2' WHEN \"math score\" BETWEEN 45.3125 AND 46.09375 AND \"reading score\" BETWEEN 76.65625 AND 85.0859375 THEN 'L_2' WHEN \"math score\" BETWEEN 53.125 AND 53.90625 AND \"reading score\" BETWEEN 76.65625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 71.09375 AND 71.875 AND \"reading score\" BETWEEN 76.65625 AND 84.4375 THEN 'L_1' WHEN \"math score\" BETWEEN 71.875 AND 75 AND \"reading score\" BETWEEN 76.65625 AND 78.6015625 THEN '' WHEN \"math score\" BETWEEN 84.375 AND 85.15625 AND \"reading score\" BETWEEN 76.65625 AND 84.4375 THEN 'L_7' WHEN \"math score\" BETWEEN 79.6875 AND 80.46875 AND \"reading score\" BETWEEN 77.3046875 AND 90.2734375 THEN '' WHEN \"math score\" BETWEEN 80.46875 AND 83.59375 AND \"reading score\" BETWEEN 77.3046875 AND 77.953125 THEN 'L_1' WHEN \"math score\" BETWEEN 83.59375 AND 84.375 AND \"reading score\" BETWEEN 77.3046875 AND 82.4921875 THEN 'L_7' WHEN \"math score\" BETWEEN 92.1875 AND 92.96875 AND \"reading score\" BETWEEN 77.3046875 AND 87.6796875 THEN 'L_2' WHEN \"math score\" BETWEEN 97.65625 AND 98.4375 AND \"reading score\" BETWEEN 77.3046875 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 80.46875 AND 81.25 AND \"reading score\" BETWEEN 77.953125 AND 90.921875 THEN '' WHEN \"math score\" BETWEEN 81.25 AND 82.8125 AND \"reading score\" BETWEEN 77.953125 AND 79.8984375 THEN 'L_1' WHEN \"math score\" BETWEEN 82.8125 AND 83.59375 AND \"reading score\" BETWEEN 77.953125 AND 78.6015625 THEN 'L_1' WHEN \"math score\" BETWEEN 44.53125 AND 45.3125 AND \"reading score\" BETWEEN 78.6015625 AND 84.4375 THEN 'L_2' WHEN \"math score\" BETWEEN 52.34375 AND 53.125 AND \"reading score\" BETWEEN 78.6015625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 71.875 AND 72.65625 AND \"reading score\" BETWEEN 78.6015625 AND 84.4375 THEN 'L_1' WHEN \"math score\" BETWEEN 72.65625 AND 75 AND \"reading score\" BETWEEN 78.6015625 AND 79.8984375 THEN '' WHEN \"math score\" BETWEEN 82.8125 AND 83.59375 AND \"reading score\" BETWEEN 78.6015625 AND 81.84375 THEN 'L_7' WHEN \"math score\" BETWEEN 96.875 AND 97.65625 AND \"reading score\" BETWEEN 78.6015625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 91.40625 AND 92.1875 AND \"reading score\" BETWEEN 79.25 AND 88.9765625 THEN 'L_2' WHEN \"math score\" BETWEEN 43.75 AND 44.53125 AND \"reading score\" BETWEEN 79.8984375 AND 83.7890625 THEN 'L_2' WHEN \"math score\" BETWEEN 72.65625 AND 73.4375 AND \"reading score\" BETWEEN 79.8984375 AND 84.4375 THEN 'L_1' WHEN \"math score\" BETWEEN 73.4375 AND 75 AND \"reading score\" BETWEEN 79.8984375 AND 80.546875 THEN '' WHEN \"math score\" BETWEEN 81.25 AND 82.03125 AND \"reading score\" BETWEEN 79.8984375 AND 92.8671875 THEN '' WHEN \"math score\" BETWEEN 82.03125 AND 82.8125 AND \"reading score\" BETWEEN 79.8984375 AND 81.1953125 THEN 'L_7' WHEN \"math score\" BETWEEN 90.625 AND 91.40625 AND \"reading score\" BETWEEN 79.8984375 AND 90.2734375 THEN 'L_2' WHEN \"math score\" BETWEEN 73.4375 AND 74.21875 AND \"reading score\" BETWEEN 80.546875 AND 84.4375 THEN 'L_1' WHEN \"math score\" BETWEEN 74.21875 AND 75 AND \"reading score\" BETWEEN 80.546875 AND 82.4921875 THEN '' WHEN \"math score\" BETWEEN 89.84375 AND 90.625 AND \"reading score\" BETWEEN 80.546875 AND 90.921875 THEN 'L_2' WHEN \"math score\" BETWEEN 96.09375 AND 96.875 AND \"reading score\" BETWEEN 80.546875 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 51.5625 AND 52.34375 AND \"reading score\" BETWEEN 81.1953125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 82.03125 AND 82.8125 AND \"reading score\" BETWEEN 81.1953125 AND 93.515625 THEN '' WHEN \"math score\" BETWEEN 82.8125 AND 83.59375 AND \"reading score\" BETWEEN 81.84375 AND 100 THEN '' WHEN \"math score\" BETWEEN 95.3125 AND 96.09375 AND \"reading score\" BETWEEN 81.84375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 50.78125 AND 51.5625 AND \"reading score\" BETWEEN 82.4921875 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 74.21875 AND 75 AND \"reading score\" BETWEEN 82.4921875 AND 84.4375 THEN 'L_1' WHEN \"math score\" BETWEEN 83.59375 AND 84.375 AND \"reading score\" BETWEEN 82.4921875 AND 100 THEN '' WHEN \"math score\" BETWEEN 89.0625 AND 89.84375 AND \"reading score\" BETWEEN 82.4921875 AND 91.5703125 THEN 'L_2' WHEN \"math score\" BETWEEN 75 AND 75.78125 AND \"reading score\" BETWEEN 83.140625 AND 84.4375 THEN 'L_1' WHEN \"math score\" BETWEEN 43.75 AND 44.53125 AND \"reading score\" BETWEEN 83.7890625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 50 AND 50.78125 AND \"reading score\" BETWEEN 83.7890625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 88.28125 AND 89.0625 AND \"reading score\" BETWEEN 83.7890625 AND 90.2734375 THEN 'L_2' WHEN \"math score\" BETWEEN 94.53125 AND 95.3125 AND \"reading score\" BETWEEN 83.7890625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 44.53125 AND 45.3125 AND \"reading score\" BETWEEN 84.4375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 49.21875 AND 50 AND \"reading score\" BETWEEN 84.4375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 64.0625 AND 76.5625 AND \"reading score\" BETWEEN 84.4375 AND 90.2734375 THEN 'L_7' WHEN \"math score\" BETWEEN 84.375 AND 85.15625 AND \"reading score\" BETWEEN 84.4375 AND 100 THEN '' WHEN \"math score\" BETWEEN 87.5 AND 88.28125 AND \"reading score\" BETWEEN 84.4375 AND 88.328125 THEN 'L_2' WHEN \"math score\" BETWEEN 45.3125 AND 49.21875 AND \"reading score\" BETWEEN 85.0859375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 63.28125 AND 64.0625 AND \"reading score\" BETWEEN 85.0859375 AND 89.625 THEN 'L_7' WHEN \"math score\" BETWEEN 76.5625 AND 77.34375 AND \"reading score\" BETWEEN 85.0859375 AND 90.2734375 THEN 'L_7' WHEN \"math score\" BETWEEN 85.15625 AND 85.9375 AND \"reading score\" BETWEEN 85.0859375 AND 100 THEN '' WHEN \"math score\" BETWEEN 86.71875 AND 87.5 AND \"reading score\" BETWEEN 85.0859375 AND 87.6796875 THEN 'L_2' WHEN \"math score\" BETWEEN 93.75 AND 94.53125 AND \"reading score\" BETWEEN 85.0859375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 62.5 AND 63.28125 AND \"reading score\" BETWEEN 85.734375 AND 88.9765625 THEN 'L_7' WHEN \"math score\" BETWEEN 85.9375 AND 86.71875 AND \"reading score\" BETWEEN 85.734375 AND 100 THEN '' WHEN \"math score\" BETWEEN 77.34375 AND 78.125 AND \"reading score\" BETWEEN 86.3828125 AND 90.2734375 THEN 'L_7' WHEN \"math score\" BETWEEN 92.96875 AND 93.75 AND \"reading score\" BETWEEN 86.3828125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 78.125 AND 78.90625 AND \"reading score\" BETWEEN 87.6796875 AND 89.625 THEN 'L_7' WHEN \"math score\" BETWEEN 86.71875 AND 87.5 AND \"reading score\" BETWEEN 87.6796875 AND 100 THEN '' WHEN \"math score\" BETWEEN 92.1875 AND 92.96875 AND \"reading score\" BETWEEN 87.6796875 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 78.90625 AND 79.6875 AND \"reading score\" BETWEEN 88.328125 AND 89.625 THEN 'L_7' WHEN \"math score\" BETWEEN 87.5 AND 88.28125 AND \"reading score\" BETWEEN 88.328125 AND 100 THEN '' WHEN \"math score\" BETWEEN 62.5 AND 63.28125 AND \"reading score\" BETWEEN 88.9765625 AND 92.21875 THEN 'L_1' WHEN \"math score\" BETWEEN 91.40625 AND 92.1875 AND \"reading score\" BETWEEN 88.9765625 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 63.28125 AND 64.0625 AND \"reading score\" BETWEEN 89.625 AND 91.5703125 THEN 'L_1' WHEN \"math score\" BETWEEN 78.125 AND 79.6875 AND \"reading score\" BETWEEN 89.625 AND 90.921875 THEN 'L_1' WHEN \"math score\" BETWEEN 64.0625 AND 78.125 AND \"reading score\" BETWEEN 90.2734375 AND 90.921875 THEN 'L_1' WHEN \"math score\" BETWEEN 79.6875 AND 80.46875 AND \"reading score\" BETWEEN 90.2734375 AND 96.7578125 THEN 'L_2' WHEN \"math score\" BETWEEN 88.28125 AND 89.0625 AND \"reading score\" BETWEEN 90.2734375 AND 100 THEN '' WHEN \"math score\" BETWEEN 90.625 AND 91.40625 AND \"reading score\" BETWEEN 90.2734375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 64.0625 AND 79.6875 AND \"reading score\" BETWEEN 90.921875 AND 96.7578125 THEN 'L_2' WHEN \"math score\" BETWEEN 80.46875 AND 81.25 AND \"reading score\" BETWEEN 90.921875 AND 96.7578125 THEN 'L_2' WHEN \"math score\" BETWEEN 89.84375 AND 90.625 AND \"reading score\" BETWEEN 90.921875 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 63.28125 AND 64.0625 AND \"reading score\" BETWEEN 91.5703125 AND 96.109375 THEN 'L_2' WHEN \"math score\" BETWEEN 89.0625 AND 89.84375 AND \"reading score\" BETWEEN 91.5703125 AND 100 THEN '' WHEN \"math score\" BETWEEN 62.5 AND 63.28125 AND \"reading score\" BETWEEN 92.21875 AND 95.4609375 THEN 'L_2' WHEN \"math score\" BETWEEN 81.25 AND 82.03125 AND \"reading score\" BETWEEN 92.8671875 AND 96.7578125 THEN 'L_2' WHEN \"math score\" BETWEEN 82.03125 AND 82.8125 AND \"reading score\" BETWEEN 93.515625 AND 96.7578125 THEN 'L_2' WHEN \"math score\" BETWEEN 62.5 AND 63.28125 AND \"reading score\" BETWEEN 95.4609375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 63.28125 AND 64.0625 AND \"reading score\" BETWEEN 96.109375 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 64.0625 AND 82.03125 AND \"reading score\" BETWEEN 96.7578125 AND 100 THEN 'L_1' WHEN \"math score\" BETWEEN 82.03125 AND 82.8125 AND \"reading score\" BETWEEN 96.7578125 AND 97.40625 THEN 'L_1' WHEN \"math score\" BETWEEN 82.03125 AND 82.8125 AND \"reading score\" BETWEEN 97.40625 AND 100 THEN '' END AS \"gw_paint_fid\", \"reading score\", \"math score\" FROM \"table_1\""; let err = test_parser(query, sql, &dataset); assert!(err.is_none()); }