| -- This file is automatically generated. You should know what you did if you want to edit this |
| -- !select_orders -- |
| 1 101 1 2 29.99 2024-01-01 |
| 2 101 2 1 49.99 2024-01-02 |
| 3 102 1 3 29.99 2024-01-03 |
| 4 102 3 1 99.98999999999999 2024-01-04 |
| 5 103 2 2 49.99 2024-01-05 |
| 6 103 1 1 29.99 2024-01-06 |
| 7 104 3 2 99.98999999999999 2024-01-07 |
| 8 104 2 3 49.99 2024-01-08 |
| 9 105 1 4 29.99 2024-01-09 |
| 10 105 3 1 99.98999999999999 2024-01-10 |
| |
| -- !select_customers -- |
| 101 Alice New York Premium |
| 102 Bob Los Angeles Standard |
| 103 Charlie Chicago Premium |
| 104 David Houston Standard |
| 105 Eve Phoenix Premium |
| |
| -- !subquery_1 -- |
| 101 109.97 |
| 102 189.96 |
| 103 129.97 |
| 104 349.95 |
| 105 219.95 |
| |
| -- !join_1 -- |
| Alice New York Premium 109.97 2 |
| Bob Los Angeles Standard 189.96 2 |
| Charlie Chicago Premium 129.97 2 |
| David Houston Standard 349.95 2 |
| Eve Phoenix Premium 219.95 2 |
| |
| -- !cte_1 -- |
| 104 David 349.95 2 |
| 105 Eve 219.95 2 |
| 102 Bob 189.96 2 |
| 103 Charlie 129.97 2 |
| 101 Alice 109.97 2 |
| |
| -- !cte_2 -- |
| Eve 219.95 |
| Charlie 129.97 |
| Alice 109.97 |
| |
| -- !nested_agg -- |
| Premium 3 459.89 |
| Standard 2 539.91 |
| |
| -- !having -- |
| Standard 539.91 4 |
| Premium 459.89 6 |
| |
| -- !self_join -- |
| 1 299.9 |
| 2 299.94 |
| 3 399.96 |
| |
| -- !union -- |
| Premium 459.89 |
| Standard 539.91 |
| |
| -- !complex_nested -- |
| Premium 153.2966666666667 219.95 109.97 |
| Standard 269.955 349.95 189.96 |
| |
