I have a polygon layer
'lot' containing an attribute
"lot_number". Then, I want to create a Virtual Layer that merges some of the lots while keeping others separated, as the diagram shows below.
Specifically, in the virtual layer, I want to merge the lots with
"lot_number" 1, 2 and 4 into one polygon, and ones with
"lot_number" 5 and 6 into another polygon. How could I do that?