def METHOD_NAME(
    self, all_data, c_range_start, c_range_end, d_range_start, d_range_end
):
    for to_select in [
        "count()",
        "sum(e)",
    ]:  # Test reading with and without column with default value
        self.query("SELECT {} FROM tab_02473;".format(to_select), False, all_data)
        delta = 10
        for b_range_start in [0, delta]:
            for b_range_end in [self.total_rows - delta]:  # , self.total_rows]:
                expected = all_data[
                    (all_data.a == 0)
                    & (all_data.b > b_range_start)
                    & (all_data.b <= b_range_end)
                ]
                self.query(
                    "SELECT {} from tab_02473 PREWHERE b > {} AND b <= {} WHERE a == 0;".format(
                        to_select, b_range_start, b_range_end
                    ),
                    False,
                    expected,
                )
                expected = all_data[
                    (all_data.a == 0)
                    & (all_data.b > b_range_start)
                    & (all_data.b <= b_range_end)
                    & (all_data.c > c_range_start)
                    & (all_data.c <= c_range_end)
                ]
                self.query(
                    "SELECT {} from tab_02473 PREWHERE b > {} AND b <= {} AND c > {} AND c <= {} WHERE a == 0;".format(
                        to_select,
                        b_range_start,
                        b_range_end,
                        c_range_start,
                        c_range_end,
                    ),
                    False,
                    expected,
                )
                expected = all_data[
                    (all_data.a == 0)
                    & (all_data.b > b_range_start)
                    & (all_data.b <= b_range_end)
                    & (all_data.c > c_range_start)
                    & (all_data.c <= c_range_end)
                    & (all_data.d > d_range_start)
                    & (all_data.d <= d_range_end)
                ]
                self.query(
                    "SELECT {} from tab_02473 PREWHERE b > {} AND b <= {} AND c > {} AND c <= {} AND d > {} AND d <= {} WHERE a == 0;".format(
                        to_select,
                        b_range_start,
                        b_range_end,
                        c_range_start,
                        c_range_end,
                        d_range_start,
                        d_range_end,
                    ),
                    False,
                    expected,
                )