Team Ai
Datasetpublic

Chulinz/Text2SQL-Decisions

Text2SQL-Decisions v0.3 28,081 English-only examples across two separate configurations. Both are template-generated, execution-validated drafts, not human-reviewed benchmarks. No model has been fine-tuned as part of this release. Configuration Rows Task License default 25,000 Four-candidate SQL plan selection on public sensor and e-commerce data CC BY 4.0 meter 3,081 Bounded meter planning decisions, including conversational context CC0-1.0 The configurations… See the full description on the dataset page: https://huggingface.co/datasets/Chulinz/Text2SQL-Decisions.

sourceHugging Facecc-by-4.0updated 22h agoView on Hugging Face
0likes27downloads
rootvalidation_report.json
validation_report.json2 linesDownload Raw Back to root
1{"artifacts":{"calibration":{"rows":1000,"sha256":"7c7bf3231f4cd8ede301a9c9bbbbdd5a16b70c7bf0683b84d49d19caa8ac90f6"},"dev":{"rows":2000,"sha256":"4eba3af159f948498ddac02199fd7f7add2bb8d862fce73dcbc217136baba432"},"test":{"rows":2000,"sha256":"3b473df1bfe2c3c9d364c6590d2bb311538f23a6d2ff2b5893a0c7e222170996"},"train":{"rows":20000,"sha256":"41a7069e6bd063c88705110dd53f9fdd7851d3503ee0c0fb40dff274e24c5720"}},"categories_by_split":{"calibration":["join/aggregate","join/and/aggregate","join/and/grouped","join/and/having","join/and/ranked","join/date/aggregate","join/date/and/aggregate","join/date/and/grouped","join/date/and/having","join/date/and/ranked","join/date/grouped","join/date/having","join/date/or/aggregate","join/date/or/grouped","join/date/or/having","join/date/or/ranked","join/date/ranked","join/distinct_invoice/aggregate","join/distinct_invoice/and/aggregate","join/distinct_invoice/and/grouped","join/distinct_invoice/and/ranked","join/distinct_invoice/date/and/aggregate","join/distinct_invoice/date/and/grouped","join/distinct_invoice/date/and/having","join/distinct_invoice/date/and/ranked","join/distinct_invoice/date/having","join/distinct_invoice/date/or/aggregate","join/distinct_invoice/date/or/grouped","join/distinct_invoice/date/or/having","join/distinct_invoice/date/or/ranked","join/distinct_invoice/having","join/distinct_invoice/null/and/grouped","join/distinct_invoice/null/and/having","join/distinct_invoice/null/and/ranked","join/distinct_invoice/null/grouped","join/distinct_invoice/null/or/grouped","join/distinct_invoice/null/or/having","join/distinct_invoice/null/or/ranked","join/distinct_invoice/or/aggregate","join/distinct_invoice/or/grouped","join/distinct_invoice/or/having","join/distinct_invoice/or/ranked","join/distinct_invoice/ranked","join/grouped","join/having","join/null/aggregate","join/null/and/aggregate","join/null/and/grouped","join/null/and/having","join/null/and/ranked","join/null/date/and/aggregate","join/null/date/and/grouped","join/null/date/and/having","join/null/date/and/ranked","join/null/date/or/aggregate","join/null/date/or/grouped","join/null/date/or/having","join/null/date/or/ranked","join/null/grouped","join/null/having","join/null/or/aggregate","join/null/or/grouped","join/null/or/having","join/null/or/ranked","join/null/ranked","join/or/aggregate","join/or/grouped","join/or/having","join/or/ranked","join/ranked","single_table/aggregate","single_table/and/aggregate","single_table/and/grouped","single_table/and/having","single_table/and/ranked","single_table/date/aggregate","single_table/date/and/aggregate","single_table/date/and/grouped","single_table/date/and/having","single_table/date/and/ranked","single_table/date/grouped","single_table/date/having","single_table/date/or/aggregate","single_table/date/or/grouped","single_table/date/or/having","single_table/date/or/ranked","single_table/date/ranked","single_table/grouped","single_table/having","single_table/or/aggregate","single_table/or/grouped","single_table/or/having","single_table/or/ranked","single_table/ranked"],"dev":["join/aggregate","join/and/aggregate","join/and/grouped","join/and/having","join/and/ranked","join/date/and/aggregate","join/date/and/grouped","join/date/and/having","join/date/and/ranked","join/date/grouped","join/date/having","join/date/or/aggregate","join/date/or/grouped","join/date/or/having","join/date/or/ranked","join/date/ranked","join/distinct_invoice/and/aggregate","join/distinct_invoice/and/grouped","join/distinct_invoice/and/having","join/distinct_invoice/and/ranked","join/distinct_invoice/date/and/grouped","join/distinct_invoice/date/and/having","join/distinct_invoice/date/and/ranked","join/distinct_invoice/date/having","join/distinct_invoice/date/or/aggregate","join/distinct_invoice/date/or/having","join/distinct_invoice/date/or/ranked","join/distinct_invoice/grouped","join/distinct_invoice/having","join/distinct_invoice/null/and/grouped","join/distinct_invoice/null/and/having","join/distinct_invoice/null/and/ranked","join/distinct_invoice/null/date/and/having","join/distinct_invoice/null/date/and/ranked","join/distinct_invoice/null/date/or/aggregate","join/distinct_invoice/null/grouped","join/distinct_invoice/null/having","join/distinct_invoice/null/or/grouped","join/distinct_invoice/null/or/having","join/distinct_invoice/or/aggregate","join/distinct_invoice/or/grouped","join/distinct_invoice/or/having","join/distinct_invoice/or/ranked","join/distinct_invoice/ranked","join/grouped","join/having","join/null/aggregate","join/null/and/aggregate","join/null/and/grouped","join/null/and/having","join/null/and/ranked","join/null/date/and/grouped","join/null/date/and/having","join/null/date/and/ranked","join/null/date/or/having","join/null/date/or/ranked","join/null/grouped","join/null/having","join/null/or/aggregate","join/null/or/grouped","join/null/or/having","join/null/or/ranked","join/null/ranked","join/or/aggregate","join/or/grouped","join/or/having","join/or/ranked","join/ranked","single_table/aggregate","single_table/and/aggregate","single_table/and/grouped","single_table/and/having","single_table/and/ranked","single_table/date/aggregate","single_table/date/and/aggregate","single_table/date/and/grouped","single_table/date/and/having","single_table/date/and/ranked","single_table/date/grouped","single_table/date/having","single_table/date/or/aggregate","single_table/date/or/grouped","single_table/date/or/having","single_table/date/or/ranked","single_table/date/ranked","single_table/grouped","single_table/having","single_table/or/aggregate","single_table/or/grouped","single_table/or/having","single_table/or/ranked","single_table/ranked"],"test":["join/aggregate","join/and/aggregate","join/and/grouped","join/and/having","join/and/ranked","join/date/and/aggregate","join/date/and/grouped","join/date/and/having","join/date/and/ranked","join/date/grouped","join/date/having","join/date/or/aggregate","join/date/or/grouped","join/date/or/having","join/date/or/ranked","join/date/ranked","join/distinct_invoice/and/aggregate","join/distinct_invoice/and/grouped","join/distinct_invoice/and/having","join/distinct_invoice/and/ranked","join/distinct_invoice/date/aggregate","join/distinct_invoice/date/and/aggregate","join/distinct_invoice/date/and/grouped","join/distinct_invoice/date/and/ranked","join/distinct_invoice/date/grouped","join/distinct_invoice/date/or/grouped","join/distinct_invoice/date/or/having","join/distinct_invoice/date/or/ranked","join/distinct_invoice/date/ranked","join/distinct_invoice/grouped","join/distinct_invoice/having","join/distinct_invoice/null/and/grouped","join/distinct_invoice/null/and/having","join/distinct_invoice/null/and/ranked","join/distinct_invoice/null/date/or/having","join/distinct_invoice/null/or/aggregate","join/distinct_invoice/null/or/having","join/distinct_invoice/null/or/ranked","join/distinct_invoice/null/ranked","join/distinct_invoice/or/aggregate","join/distinct_invoice/or/grouped","join/distinct_invoice/or/having","join/distinct_invoice/or/ranked","join/distinct_invoice/ranked","join/grouped","join/having","join/null/aggregate","join/null/and/aggregate","join/null/and/grouped","join/null/and/having","join/null/and/ranked","join/null/date/and/grouped","join/null/date/and/having","join/null/date/and/ranked","join/null/date/or/having","join/null/date/or/ranked","join/null/grouped","join/null/having","join/null/or/aggregate","join/null/or/grouped","join/null/or/having","join/null/or/ranked","join/null/ranked","join/or/aggregate","join/or/grouped","join/or/having","join/or/ranked","join/ranked","single_table/aggregate","single_table/and/aggregate","single_table/and/grouped","single_table/and/having","single_table/and/ranked","single_table/date/aggregate","single_table/date/and/aggregate","single_table/date/and/grouped","single_table/date/and/having","single_table/date/and/ranked","single_table/date/grouped","single_table/date/having","single_table/date/or/aggregate","single_table/date/or/grouped","single_table/date/or/having","single_table/date/or/ranked","single_table/date/ranked","single_table/grouped","single_table/having","single_table/or/aggregate","single_table/or/grouped","single_table/or/having","single_table/or/ranked","single_table/ranked"],"train":["join/aggregate","join/and/aggregate","join/and/grouped","join/and/having","join/and/ranked","join/date/aggregate","join/date/and/aggregate","join/date/and/grouped","join/date/and/having","join/date/and/ranked","join/date/grouped","join/date/having","join/date/or/aggregate","join/date/or/grouped","join/date/or/having","join/date/or/ranked","join/date/ranked","join/distinct_invoice/aggregate","join/distinct_invoice/and/aggregate","join/distinct_invoice/and/grouped","join/distinct_invoice/and/having","join/distinct_invoice/and/ranked","join/distinct_invoice/date/and/aggregate","join/distinct_invoice/date/and/grouped","join/distinct_invoice/date/and/having","join/distinct_invoice/date/and/ranked","join/distinct_invoice/date/grouped","join/distinct_invoice/date/having","join/distinct_invoice/date/or/aggregate","join/distinct_invoice/date/or/grouped","join/distinct_invoice/date/or/having","join/distinct_invoice/date/or/ranked","join/distinct_invoice/date/ranked","join/distinct_invoice/grouped","join/distinct_invoice/having","join/distinct_invoice/null/aggregate","join/distinct_invoice/null/and/aggregate","join/distinct_invoice/null/and/grouped","join/distinct_invoice/null/and/having","join/distinct_invoice/null/and/ranked","join/distinct_invoice/null/date/and/aggregate","join/distinct_invoice/null/date/and/grouped","join/distinct_invoice/null/date/and/having","join/distinct_invoice/null/date/and/ranked","join/distinct_invoice/null/date/or/grouped","join/distinct_invoice/null/date/or/having","join/distinct_invoice/null/date/or/ranked","join/distinct_invoice/null/grouped","join/distinct_invoice/null/having","join/distinct_invoice/null/or/aggregate","join/distinct_invoice/null/or/grouped","join/distinct_invoice/null/or/having","join/distinct_invoice/null/or/ranked","join/distinct_invoice/null/ranked","join/distinct_invoice/or/aggregate","join/distinct_invoice/or/grouped","join/distinct_invoice/or/having","join/distinct_invoice/or/ranked","join/distinct_invoice/ranked","join/grouped","join/having","join/null/aggregate","join/null/and/aggregate","join/null/and/grouped","join/null/and/having","join/null/and/ranked","join/null/date/and/aggregate","join/null/date/and/grouped","join/null/date/and/having","join/null/date/and/ranked","join/null/date/or/aggregate","join/null/date/or/grouped","join/null/date/or/having","join/null/date/or/ranked","join/null/grouped","join/null/having","join/null/or/aggregate","join/null/or/grouped","join/null/or/having","join/null/or/ranked","join/null/ranked","join/or/aggregate","join/or/grouped","join/or/having","join/or/ranked","join/ranked","single_table/aggregate","single_table/and/aggregate","single_table/and/grouped","single_table/and/having","single_table/and/ranked","single_table/date/aggregate","single_table/date/and/aggregate","single_table/date/and/grouped","single_table/date/and/having","single_table/date/and/ranked","single_table/date/grouped","single_table/date/having","single_table/date/or/aggregate","single_table/date/or/grouped","single_table/date/or/having","single_table/date/or/ranked","single_table/date/ranked","single_table/grouped","single_table/having","single_table/or/aggregate","single_table/or/grouped","single_table/or/having","single_table/or/ranked","single_table/ranked"]},"counts":{"calibration:hydraulic:single_table/aggregate":10,"calibration:hydraulic:single_table/and/aggregate":10,"calibration:hydraulic:single_table/and/grouped":10,"calibration:hydraulic:single_table/and/having":10,"calibration:hydraulic:single_table/and/ranked":10,"calibration:hydraulic:single_table/grouped":10,"calibration:hydraulic:single_table/having":10,"calibration:hydraulic:single_table/or/aggregate":10,"calibration:hydraulic:single_table/or/grouped":10,"calibration:hydraulic:single_table/or/having":10,"calibration:hydraulic:single_table/or/ranked":10,"calibration:hydraulic:single_table/ranked":10,"calibration:online_retail_ii:join/aggregate":10,"calibration:online_retail_ii:join/and/aggregate":10,"calibration:online_retail_ii:join/and/grouped":10,"calibration:online_retail_ii:join/and/having":10,"calibration:online_retail_ii:join/and/ranked":10,"calibration:online_retail_ii:join/date/aggregate":10,"calibration:online_retail_ii:join/date/and/aggregate":10,"calibration:online_retail_ii:join/date/and/grouped":10,"calibration:online_retail_ii:join/date/and/having":10,"calibration:online_retail_ii:join/date/and/ranked":10,"calibration:online_retail_ii:join/date/grouped":10,"calibration:online_retail_ii:join/date/having":10,"calibration:online_retail_ii:join/date/or/aggregate":10,"calibration:online_retail_ii:join/date/or/grouped":10,"calibration:online_retail_ii:join/date/or/having":10,"calibration:online_retail_ii:join/date/or/ranked":10,"calibration:online_retail_ii:join/date/ranked":10,"calibration:online_retail_ii:join/distinct_invoice/aggregate":10,"calibration:online_retail_ii:join/distinct_invoice/and/aggregate":10,"calibration:online_retail_ii:join/distinct_invoice/and/grouped":3,"calibration:online_retail_ii:join/distinct_invoice/and/ranked":9,"calibration:online_retail_ii:join/distinct_invoice/date/and/aggregate":4,"calibration:online_retail_ii:join/distinct_invoice/date/and/grouped":10,"calibration:online_retail_ii:join/distinct_invoice/date/and/having":10,"calibration:online_retail_ii:join/distinct_invoice/date/and/ranked":10,"calibration:online_retail_ii:join/distinct_invoice/date/having":10,"calibration:online_retail_ii:join/distinct_invoice/date/or/aggregate":7,"calibration:online_retail_ii:join/distinct_invoice/date/or/grouped":9,"calibration:online_retail_ii:join/distinct_invoice/date/or/having":10,"calibration:online_retail_ii:join/distinct_invoice/date/or/ranked":10,"calibration:online_retail_ii:join/distinct_invoice/having":5,"calibration:online_retail_ii:join/distinct_invoice/null/and/grouped":2,"calibration:online_retail_ii:join/distinct_invoice/null/and/having":2,"calibration:online_retail_ii:join/distinct_invoice/null/and/ranked":2,"calibration:online_retail_ii:join/distinct_invoice/null/grouped":1,"calibration:online_retail_ii:join/distinct_invoice/null/or/grouped":4,"calibration:online_retail_ii:join/distinct_invoice/null/or/having":3,"calibration:online_retail_ii:join/distinct_invoice/null/or/ranked":6,"calibration:online_retail_ii:join/distinct_invoice/or/aggregate":10,"calibration:online_retail_ii:join/distinct_invoice/or/grouped":10,"calibration:online_retail_ii:join/distinct_invoice/or/having":10,"calibration:online_retail_ii:join/distinct_invoice/or/ranked":10,"calibration:online_retail_ii:join/distinct_invoice/ranked":10,"calibration:online_retail_ii:join/grouped":10,"calibration:online_retail_ii:join/having":10,"calibration:online_retail_ii:join/null/aggregate":3,"calibration:online_retail_ii:join/null/and/aggregate":7,"calibration:online_retail_ii:join/null/and/grouped":10,"calibration:online_retail_ii:join/null/and/having":10,"calibration:online_retail_ii:join/null/and/ranked":10,"calibration:online_retail_ii:join/null/date/and/aggregate":2,"calibration:online_retail_ii:join/null/date/and/grouped":2,"calibration:online_retail_ii:join/null/date/and/having":6,"calibration:online_retail_ii:join/null/date/and/ranked":6,"calibration:online_retail_ii:join/null/date/or/aggregate":4,"calibration:online_retail_ii:join/null/date/or/grouped":6,"calibration:online_retail_ii:join/null/date/or/having":8,"calibration:online_retail_ii:join/null/date/or/ranked":6,"calibration:online_retail_ii:join/null/grouped":2,"calibration:online_retail_ii:join/null/having":7,"calibration:online_retail_ii:join/null/or/aggregate":10,"calibration:online_retail_ii:join/null/or/grouped":10,"calibration:online_retail_ii:join/null/or/having":10,"calibration:online_retail_ii:join/null/or/ranked":10,"calibration:online_retail_ii:join/null/ranked":4,"calibration:online_retail_ii:join/or/aggregate":10,"calibration:online_retail_ii:join/or/grouped":10,"calibration:online_retail_ii:join/or/having":10,"calibration:online_retail_ii:join/or/ranked":10,"calibration:online_retail_ii:join/ranked":10,"calibration:online_retail_ii:single_table/aggregate":1,"calibration:online_retail_ii:single_table/and/aggregate":10,"calibration:online_retail_ii:single_table/and/grouped":10,"calibration:online_retail_ii:single_table/and/having":10,"calibration:online_retail_ii:single_table/and/ranked":10,"calibration:online_retail_ii:single_table/date/aggregate":5,"calibration:online_retail_ii:single_table/date/and/aggregate":10,"calibration:online_retail_ii:single_table/date/and/grouped":10,"calibration:online_retail_ii:single_table/date/and/having":10,"calibration:online_retail_ii:single_table/date/and/ranked":10,"calibration:online_retail_ii:single_table/date/grouped":9,"calibration:online_retail_ii:single_table/date/having":9,"calibration:online_retail_ii:single_table/date/or/aggregate":9,"calibration:online_retail_ii:single_table/date/or/grouped":9,"calibration:online_retail_ii:single_table/date/or/having":9,"calibration:online_retail_ii:single_table/date/or/ranked":9,"calibration:online_retail_ii:single_table/date/ranked":9,"calibration:online_retail_ii:single_table/grouped":9,"calibration:online_retail_ii:single_table/having":9,"calibration:online_retail_ii:single_table/or/aggregate":9,"calibration:online_retail_ii:single_table/or/grouped":9,"calibration:online_retail_ii:single_table/or/having":9,"calibration:online_retail_ii:single_table/or/ranked":9,"calibration:online_retail_ii:single_table/ranked":9,"calibration:online_shoppers:single_table/aggregate":9,"calibration:online_shoppers:single_table/and/aggregate":9,"calibration:online_shoppers:single_table/and/grouped":9,"calibration:online_shoppers:single_table/and/having":9,"calibration:online_shoppers:single_table/and/ranked":9,"calibration:online_shoppers:single_table/grouped":9,"calibration:online_shoppers:single_table/having":9,"calibration:online_shoppers:single_table/or/aggregate":9,"calibration:online_shoppers:single_table/or/grouped":9,"calibration:online_shoppers:single_table/or/having":9,"calibration:online_shoppers:single_table/or/ranked":9,"calibration:online_shoppers:single_table/ranked":9,"dev:hydraulic:single_table/aggregate":23,"dev:hydraulic:single_table/and/aggregate":23,"dev:hydraulic:single_table/and/grouped":23,"dev:hydraulic:single_table/and/having":23,"dev:hydraulic:single_table/and/ranked":23,"dev:hydraulic:single_table/grouped":23,"dev:hydraulic:single_table/having":23,"dev:hydraulic:single_table/or/aggregate":23,"dev:hydraulic:single_table/or/grouped":23,"dev:hydraulic:single_table/or/having":23,"dev:hydraulic:single_table/or/ranked":23,"dev:hydraulic:single_table/ranked":23,"dev:online_retail_ii:join/aggregate":23,"dev:online_retail_ii:join/and/aggregate":22,"dev:online_retail_ii:join/and/grouped":23,"dev:online_retail_ii:join/and/having":23,"dev:online_retail_ii:join/and/ranked":17,"dev:online_retail_ii:join/date/and/aggregate":23,"dev:online_retail_ii:join/date/and/grouped":23,"dev:online_retail_ii:join/date/and/having":23,"dev:online_retail_ii:join/date/and/ranked":23,"dev:online_retail_ii:join/date/grouped":23,"dev:online_retail_ii:join/date/having":23,"dev:online_retail_ii:join/date/or/aggregate":23,"dev:online_retail_ii:join/date/or/grouped":23,"dev:online_retail_ii:join/date/or/having":23,"dev:online_retail_ii:join/date/or/ranked":20,"dev:online_retail_ii:join/date/ranked":20,"dev:online_retail_ii:join/distinct_invoice/and/aggregate":3,"dev:online_retail_ii:join/distinct_invoice/and/grouped":1,"dev:online_retail_ii:join/distinct_invoice/and/having":19,"dev:online_retail_ii:join/distinct_invoice/and/ranked":21,"dev:online_retail_ii:join/distinct_invoice/date/and/grouped":8,"dev:online_retail_ii:join/distinct_invoice/date/and/having":23,"dev:online_retail_ii:join/distinct_invoice/date/and/ranked":5,"dev:online_retail_ii:join/distinct_invoice/date/having":5,"dev:online_retail_ii:join/distinct_invoice/date/or/aggregate":4,"dev:online_retail_ii:join/distinct_invoice/date/or/having":12,"dev:online_retail_ii:join/distinct_invoice/date/or/ranked":10,"dev:online_retail_ii:join/distinct_invoice/grouped":21,"dev:online_retail_ii:join/distinct_invoice/having":10,"dev:online_retail_ii:join/distinct_invoice/null/and/grouped":3,"dev:online_retail_ii:join/distinct_invoice/null/and/having":1,"dev:online_retail_ii:join/distinct_invoice/null/and/ranked":1,"dev:online_retail_ii:join/distinct_invoice/null/date/and/having":2,"dev:online_retail_ii:join/distinct_invoice/null/date/and/ranked":2,"dev:online_retail_ii:join/distinct_invoice/null/date/or/aggregate":2,"dev:online_retail_ii:join/distinct_invoice/null/grouped":1,"dev:online_retail_ii:join/distinct_invoice/null/having":1,"dev:online_retail_ii:join/distinct_invoice/null/or/grouped":1,"dev:online_retail_ii:join/distinct_invoice/null/or/having":2,"dev:online_retail_ii:join/distinct_invoice/or/aggregate":5,"dev:online_retail_ii:join/distinct_invoice/or/grouped":7,"dev:online_retail_ii:join/distinct_invoice/or/having":21,"dev:online_retail_ii:join/distinct_invoice/or/ranked":23,"dev:online_retail_ii:join/distinct_invoice/ranked":5,"dev:online_retail_ii:join/grouped":23,"dev:online_retail_ii:join/having":23,"dev:online_retail_ii:join/null/aggregate":4,"dev:online_retail_ii:join/null/and/aggregate":3,"dev:online_retail_ii:join/null/and/grouped":10,"dev:online_retail_ii:join/null/and/having":23,"dev:online_retail_ii:join/null/and/ranked":21,"dev:online_retail_ii:join/null/date/and/grouped":4,"dev:online_retail_ii:join/null/date/and/having":6,"dev:online_retail_ii:join/null/date/and/ranked":2,"dev:online_retail_ii:join/null/date/or/having":4,"dev:online_retail_ii:join/null/date/or/ranked":10,"dev:online_retail_ii:join/null/grouped":4,"dev:online_retail_ii:join/null/having":8,"dev:online_retail_ii:join/null/or/aggregate":9,"dev:online_retail_ii:join/null/or/grouped":21,"dev:online_retail_ii:join/null/or/having":19,"dev:online_retail_ii:join/null/or/ranked":23,"dev:online_retail_ii:join/null/ranked":7,"dev:online_retail_ii:join/or/aggregate":21,"dev:online_retail_ii:join/or/grouped":23,"dev:online_retail_ii:join/or/having":23,"dev:online_retail_ii:join/or/ranked":22,"dev:online_retail_ii:join/ranked":23,"dev:online_retail_ii:single_table/aggregate":23,"dev:online_retail_ii:single_table/and/aggregate":23,"dev:online_retail_ii:single_table/and/grouped":23,"dev:online_retail_ii:single_table/and/having":23,"dev:online_retail_ii:single_table/and/ranked":23,"dev:online_retail_ii:single_table/date/aggregate":10,"dev:online_retail_ii:single_table/date/and/aggregate":23,"dev:online_retail_ii:single_table/date/and/grouped":23,"dev:online_retail_ii:single_table/date/and/having":23,"dev:online_retail_ii:single_table/date/and/ranked":23,"dev:online_retail_ii:single_table/date/grouped":23,"dev:online_retail_ii:single_table/date/having":23,"dev:online_retail_ii:single_table/date/or/aggregate":23,"dev:online_retail_ii:single_table/date/or/grouped":23,"dev:online_retail_ii:single_table/date/or/having":23,"dev:online_retail_ii:single_table/date/or/ranked":23,"dev:online_retail_ii:single_table/date/ranked":23,"dev:online_retail_ii:single_table/grouped":23,"dev:online_retail_ii:single_table/having":23,"dev:online_retail_ii:single_table/or/aggregate":23,"dev:online_retail_ii:single_table/or/grouped":23,"dev:online_retail_ii:single_table/or/having":23,"dev:online_retail_ii:single_table/or/ranked":23,"dev:online_retail_ii:single_table/ranked":23,"dev:online_shoppers:single_table/aggregate":23,"dev:online_shoppers:single_table/and/aggregate":23,"dev:online_shoppers:single_table/and/grouped":23,"dev:online_shoppers:single_table/and/having":23,"dev:online_shoppers:single_table/and/ranked":23,"dev:online_shoppers:single_table/grouped":23,"dev:online_shoppers:single_table/having":23,"dev:online_shoppers:single_table/or/aggregate":23,"dev:online_shoppers:single_table/or/grouped":23,"dev:online_shoppers:single_table/or/having":23,"dev:online_shoppers:single_table/or/ranked":23,"dev:online_shoppers:single_table/ranked":22,"test:hydraulic:single_table/aggregate":23,"test:hydraulic:single_table/and/aggregate":23,"test:hydraulic:single_table/and/grouped":23,"test:hydraulic:single_table/and/having":23,"test:hydraulic:single_table/and/ranked":23,"test:hydraulic:single_table/grouped":23,"test:hydraulic:single_table/having":23,"test:hydraulic:single_table/or/aggregate":23,"test:hydraulic:single_table/or/grouped":23,"test:hydraulic:single_table/or/having":23,"test:hydraulic:single_table/or/ranked":23,"test:hydraulic:single_table/ranked":23,"test:online_retail_ii:join/aggregate":23,"test:online_retail_ii:join/and/aggregate":23,"test:online_retail_ii:join/and/grouped":23,"test:online_retail_ii:join/and/having":23,"test:online_retail_ii:join/and/ranked":23,"test:online_retail_ii:join/date/and/aggregate":23,"test:online_retail_ii:join/date/and/grouped":23,"test:online_retail_ii:join/date/and/having":23,"test:online_retail_ii:join/date/and/ranked":21,"test:online_retail_ii:join/date/grouped":15,"test:online_retail_ii:join/date/having":23,"test:online_retail_ii:join/date/or/aggregate":23,"test:online_retail_ii:join/date/or/grouped":23,"test:online_retail_ii:join/date/or/having":23,"test:online_retail_ii:join/date/or/ranked":23,"test:online_retail_ii:join/date/ranked":23,"test:online_retail_ii:join/distinct_invoice/and/aggregate":1,"test:online_retail_ii:join/distinct_invoice/and/grouped":23,"test:online_retail_ii:join/distinct_invoice/and/having":22,"test:online_retail_ii:join/distinct_invoice/and/ranked":23,"test:online_retail_ii:join/distinct_invoice/date/aggregate":10,"test:online_retail_ii:join/distinct_invoice/date/and/aggregate":3,"test:online_retail_ii:join/distinct_invoice/date/and/grouped":3,"test:online_retail_ii:join/distinct_invoice/date/and/ranked":11,"test:online_retail_ii:join/distinct_invoice/date/grouped":5,"test:online_retail_ii:join/distinct_invoice/date/or/grouped":3,"test:online_retail_ii:join/distinct_invoice/date/or/having":8,"test:online_retail_ii:join/distinct_invoice/date/or/ranked":12,"test:online_retail_ii:join/distinct_invoice/date/ranked":5,"test:online_retail_ii:join/distinct_invoice/grouped":10,"test:online_retail_ii:join/distinct_invoice/having":22,"test:online_retail_ii:join/distinct_invoice/null/and/grouped":3,"test:online_retail_ii:join/distinct_invoice/null/and/having":8,"test:online_retail_ii:join/distinct_invoice/null/and/ranked":6,"test:online_retail_ii:join/distinct_invoice/null/date/or/having":2,"test:online_retail_ii:join/distinct_invoice/null/or/aggregate":1,"test:online_retail_ii:join/distinct_invoice/null/or/having":1,"test:online_retail_ii:join/distinct_invoice/null/or/ranked":1,"test:online_retail_ii:join/distinct_invoice/null/ranked":1,"test:online_retail_ii:join/distinct_invoice/or/aggregate":3,"test:online_retail_ii:join/distinct_invoice/or/grouped":19,"test:online_retail_ii:join/distinct_invoice/or/having":22,"test:online_retail_ii:join/distinct_invoice/or/ranked":22,"test:online_retail_ii:join/distinct_invoice/ranked":15,"test:online_retail_ii:join/grouped":19,"test:online_retail_ii:join/having":22,"test:online_retail_ii:join/null/aggregate":1,"test:online_retail_ii:join/null/and/aggregate":8,"test:online_retail_ii:join/null/and/grouped":17,"test:online_retail_ii:join/null/and/having":18,"test:online_retail_ii:join/null/and/ranked":22,"test:online_retail_ii:join/null/date/and/grouped":8,"test:online_retail_ii:join/null/date/and/having":12,"test:online_retail_ii:join/null/date/and/ranked":2,"test:online_retail_ii:join/null/date/or/having":6,"test:online_retail_ii:join/null/date/or/ranked":10,"test:online_retail_ii:join/null/grouped":2,"test:online_retail_ii:join/null/having":7,"test:online_retail_ii:join/null/or/aggregate":6,"test:online_retail_ii:join/null/or/grouped":16,"test:online_retail_ii:join/null/or/having":22,"test:online_retail_ii:join/null/or/ranked":22,"test:online_retail_ii:join/null/ranked":5,"test:online_retail_ii:join/or/aggregate":22,"test:online_retail_ii:join/or/grouped":22,"test:online_retail_ii:join/or/having":22,"test:online_retail_ii:join/or/ranked":22,"test:online_retail_ii:join/ranked":22,"test:online_retail_ii:single_table/aggregate":20,"test:online_retail_ii:single_table/and/aggregate":22,"test:online_retail_ii:single_table/and/grouped":22,"test:online_retail_ii:single_table/and/having":22,"test:online_retail_ii:single_table/and/ranked":22,"test:online_retail_ii:single_table/date/aggregate":5,"test:online_retail_ii:single_table/date/and/aggregate":22,"test:online_retail_ii:single_table/date/and/grouped":22,"test:online_retail_ii:single_table/date/and/having":22,"test:online_retail_ii:single_table/date/and/ranked":22,"test:online_retail_ii:single_table/date/grouped":15,"test:online_retail_ii:single_table/date/having":22,"test:online_retail_ii:single_table/date/or/aggregate":22,"test:online_retail_ii:single_table/date/or/grouped":22,"test:online_retail_ii:single_table/date/or/having":22,"test:online_retail_ii:single_table/date/or/ranked":22,"test:online_retail_ii:single_table/date/ranked":22,"test:online_retail_ii:single_table/grouped":22,"test:online_retail_ii:single_table/having":22,"test:online_retail_ii:single_table/or/aggregate":22,"test:online_retail_ii:single_table/or/grouped":22,"test:online_retail_ii:single_table/or/having":22,"test:online_retail_ii:single_table/or/ranked":22,"test:online_retail_ii:single_table/ranked":22,"test:online_shoppers:single_table/aggregate":22,"test:online_shoppers:single_table/and/aggregate":22,"test:online_shoppers:single_table/and/grouped":22,"test:online_shoppers:single_table/and/having":22,"test:online_shoppers:single_table/and/ranked":22,"test:online_shoppers:single_table/grouped":22,"test:online_shoppers:single_table/having":22,"test:online_shoppers:single_table/or/aggregate":22,"test:online_shoppers:single_table/or/grouped":22,"test:online_shoppers:single_table/or/having":22,"test:online_shoppers:single_table/or/ranked":22,"test:online_shoppers:single_table/ranked":22,"train:hydraulic:single_table/aggregate":250,"train:hydraulic:single_table/and/aggregate":250,"train:hydraulic:single_table/and/grouped":250,"train:hydraulic:single_table/and/having":250,"train:hydraulic:single_table/and/ranked":250,"train:hydraulic:single_table/grouped":250,"train:hydraulic:single_table/having":250,"train:hydraulic:single_table/or/aggregate":250,"train:hydraulic:single_table/or/grouped":250,"train:hydraulic:single_table/or/having":250,"train:hydraulic:single_table/or/ranked":250,"train:hydraulic:single_table/ranked":250,"train:online_retail_ii:join/aggregate":191,"train:online_retail_ii:join/and/aggregate":202,"train:online_retail_ii:join/and/grouped":221,"train:online_retail_ii:join/and/having":188,"train:online_retail_ii:join/and/ranked":218,"train:online_retail_ii:join/date/aggregate":75,"train:online_retail_ii:join/date/and/aggregate":192,"train:online_retail_ii:join/date/and/grouped":186,"train:online_retail_ii:join/date/and/having":204,"train:online_retail_ii:join/date/and/ranked":219,"train:online_retail_ii:join/date/grouped":115,"train:online_retail_ii:join/date/having":219,"train:online_retail_ii:join/date/or/aggregate":187,"train:online_retail_ii:join/date/or/grouped":215,"train:online_retail_ii:join/date/or/having":203,"train:online_retail_ii:join/date/or/ranked":206,"train:online_retail_ii:join/date/ranked":203,"train:online_retail_ii:join/distinct_invoice/aggregate":26,"train:online_retail_ii:join/distinct_invoice/and/aggregate":49,"train:online_retail_ii:join/distinct_invoice/and/grouped":100,"train:online_retail_ii:join/distinct_invoice/and/having":226,"train:online_retail_ii:join/distinct_invoice/and/ranked":218,"train:online_retail_ii:join/distinct_invoice/date/and/aggregate":35,"train:online_retail_ii:join/distinct_invoice/date/and/grouped":62,"train:online_retail_ii:join/distinct_invoice/date/and/having":131,"train:online_retail_ii:join/distinct_invoice/date/and/ranked":132,"train:online_retail_ii:join/distinct_invoice/date/grouped":15,"train:online_retail_ii:join/distinct_invoice/date/having":25,"train:online_retail_ii:join/distinct_invoice/date/or/aggregate":31,"train:online_retail_ii:join/distinct_invoice/date/or/grouped":72,"train:online_retail_ii:join/distinct_invoice/date/or/having":129,"train:online_retail_ii:join/distinct_invoice/date/or/ranked":122,"train:online_retail_ii:join/distinct_invoice/date/ranked":35,"train:online_retail_ii:join/distinct_invoice/grouped":51,"train:online_retail_ii:join/distinct_invoice/having":118,"train:online_retail_ii:join/distinct_invoice/null/aggregate":2,"train:online_retail_ii:join/distinct_invoice/null/and/aggregate":7,"train:online_retail_ii:join/distinct_invoice/null/and/grouped":6,"train:online_retail_ii:join/distinct_invoice/null/and/having":17,"train:online_retail_ii:join/distinct_invoice/null/and/ranked":19,"train:online_retail_ii:join/distinct_invoice/null/date/and/aggregate":2,"train:online_retail_ii:join/distinct_invoice/null/date/and/grouped":4,"train:online_retail_ii:join/distinct_invoice/null/date/and/having":6,"train:online_retail_ii:join/distinct_invoice/null/date/and/ranked":6,"train:online_retail_ii:join/distinct_invoice/null/date/or/grouped":4,"train:online_retail_ii:join/distinct_invoice/null/date/or/having":6,"train:online_retail_ii:join/distinct_invoice/null/date/or/ranked":8,"train:online_retail_ii:join/distinct_invoice/null/grouped":2,"train:online_retail_ii:join/distinct_invoice/null/having":7,"train:online_retail_ii:join/distinct_invoice/null/or/aggregate":6,"train:online_retail_ii:join/distinct_invoice/null/or/grouped":9,"train:online_retail_ii:join/distinct_invoice/null/or/having":22,"train:online_retail_ii:join/distinct_invoice/null/or/ranked":21,"train:online_retail_ii:join/distinct_invoice/null/ranked":7,"train:online_retail_ii:join/distinct_invoice/or/aggregate":45,"train:online_retail_ii:join/distinct_invoice/or/grouped":74,"train:online_retail_ii:join/distinct_invoice/or/having":188,"train:online_retail_ii:join/distinct_invoice/or/ranked":158,"train:online_retail_ii:join/distinct_invoice/ranked":108,"train:online_retail_ii:join/grouped":218,"train:online_retail_ii:join/having":192,"train:online_retail_ii:join/null/aggregate":10,"train:online_retail_ii:join/null/and/aggregate":45,"train:online_retail_ii:join/null/and/grouped":86,"train:online_retail_ii:join/null/and/having":179,"train:online_retail_ii:join/null/and/ranked":183,"train:online_retail_ii:join/null/date/and/aggregate":16,"train:online_retail_ii:join/null/date/and/grouped":22,"train:online_retail_ii:join/null/date/and/having":48,"train:online_retail_ii:join/null/date/and/ranked":62,"train:online_retail_ii:join/null/date/or/aggregate":14,"train:online_retail_ii:join/null/date/or/grouped":30,"train:online_retail_ii:join/null/date/or/having":54,"train:online_retail_ii:join/null/date/or/ranked":46,"train:online_retail_ii:join/null/grouped":28,"train:online_retail_ii:join/null/having":50,"train:online_retail_ii:join/null/or/aggregate":36,"train:online_retail_ii:join/null/or/grouped":76,"train:online_retail_ii:join/null/or/having":168,"train:online_retail_ii:join/null/or/ranked":179,"train:online_retail_ii:join/null/ranked":56,"train:online_retail_ii:join/or/aggregate":221,"train:online_retail_ii:join/or/grouped":198,"train:online_retail_ii:join/or/having":195,"train:online_retail_ii:join/or/ranked":209,"train:online_retail_ii:join/ranked":199,"train:online_retail_ii:single_table/aggregate":207,"train:online_retail_ii:single_table/and/aggregate":250,"train:online_retail_ii:single_table/and/grouped":250,"train:online_retail_ii:single_table/and/having":250,"train:online_retail_ii:single_table/and/ranked":250,"train:online_retail_ii:single_table/date/aggregate":70,"train:online_retail_ii:single_table/date/and/aggregate":250,"train:online_retail_ii:single_table/date/and/grouped":250,"train:online_retail_ii:single_table/date/and/having":250,"train:online_retail_ii:single_table/date/and/ranked":250,"train:online_retail_ii:single_table/date/grouped":110,"train:online_retail_ii:single_table/date/having":245,"train:online_retail_ii:single_table/date/or/aggregate":250,"train:online_retail_ii:single_table/date/or/grouped":250,"train:online_retail_ii:single_table/date/or/having":250,"train:online_retail_ii:single_table/date/or/ranked":250,"train:online_retail_ii:single_table/date/ranked":250,"train:online_retail_ii:single_table/grouped":250,"train:online_retail_ii:single_table/having":250,"train:online_retail_ii:single_table/or/aggregate":250,"train:online_retail_ii:single_table/or/grouped":250,"train:online_retail_ii:single_table/or/having":250,"train:online_retail_ii:single_table/or/ranked":250,"train:online_retail_ii:single_table/ranked":250,"train:online_shoppers:single_table/aggregate":250,"train:online_shoppers:single_table/and/aggregate":250,"train:online_shoppers:single_table/and/grouped":250,"train:online_shoppers:single_table/and/having":250,"train:online_shoppers:single_table/and/ranked":250,"train:online_shoppers:single_table/grouped":249,"train:online_shoppers:single_table/having":249,"train:online_shoppers:single_table/or/aggregate":249,"train:online_shoppers:single_table/or/grouped":249,"train:online_shoppers:single_table/or/having":249,"train:online_shoppers:single_table/or/ranked":249,"train:online_shoppers:single_table/ranked":249},"database_sha256":"6a8f09371963b100f93b3fe4ff763ef1b25ca561a576bb113818ed66353780d3","exact_state_duplicates":0,"families":14725,"family_overlap":0,"generator_sha256":"6377fec0082f1a9387849b23e5af69839a62926efc1127525431262791c43c0a","human_review_complete":false,"language":"en","model_training_performed":false,"pool_rows":47973,"pool_sha256":"bfd012665dbeb833c04acf85dc3d1af527e21aa1cba1c2f38445b723d21ef27b","rows":25000,"sql_dialect":"sqlite","status":"execution_validated_draft","version":"0.2"}2