add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version()
5.6.51
vin model category sale_id vs_vin vs_sale_id vs_price
v1 m1 car 1 v1 1 100
v2 m2 car 2 v2 2 200
v3 m2 car 3 v3 3 300
v4 m2 car 4 v4 4 400
v5 m5 elmo 5 v5 5 500
v6 m6 elmo 6 v6 6 600
v7 m6 elmo 7 v7 7 700
v9 m9 truck 9 v9 9 800
v12 m10 truck 12 v12 12 900
v13 m10 truck 13 v13 13 1000
v14 m10 truck 14 v14 14 1100
vin model category vs_vin vs_sale_id vs_price
v1 m1 car v1 1 100
v2 m2 car v2 2 200
v3 m2 car v3 3 300
v4 m2 car v4 4 400
v5 m5 elmo v5 5 500
v6 m6 elmo v6 6 600
v7 m6 elmo v7 7 700
v9 m9 truck v9 9 800
v12 m10 truck v12 12 900
v13 m10 truck v13 13 1000
v14 m10 truck v14 14 1100
model category sale_id
m1 car 1
m2 car 2
m2 car 3
m2 car 4
m5 elmo 5
m6 elmo 6
m6 elmo 7
m9 truck 9
m10 truck 12
m10 truck 13
m10 truck 14
category model cnt
car m2 3
car m1 1
elmo m6 2
elmo m5 1
truck m10 3
truck m9 1
category mcnt
car 3
elmo 2
truck 3
category model cnt category mcnt
car m2 3 car 3
elmo m6 2 elmo 2
truck m10 3 truck 3