To identify the queries that only return the shape 'CUBE' from the BRICKS table, we need to consider the weight constraints given by the BOXES table. The shape 'CUBE' has a weight of 5, which falls within the 'MIN_WEIGHT' of 0 and 'MAX_WEIGHT' of 10 range for 'SMALL' boxes. Option A uses 'BETWEEN', which includes both the lower (0) and upper (10) bounds, making it correct for selecting shapes with weights within this range, including 5. Option C uses 'weight >= min_weight AND weight < max_weight', which also correctly includes 5 but excludes 10, ensuring the 'CUBE' is selected while excluding shapes with weights that don't fall within this exact range. Therefore, options A and C are the correct queries that only return 'CUBE'.