mysql - SQL cross table based on two columns -

i want make cross table in mysql based on 2 columns in table. 1 evidence number of bus: called "boczny" (without repetitions in column) , number of lane: "linia". try convert "linia" column row, , count how evidence bus seen on given lane.

acutualy have this, still mising pivot table (cross table).

please help.

select boczny, min(linia)  vehicles group boczny 

a typical way uses conditional aggregation:

select v.boczny,        sum(v.linia = 1) linia_1,        sum(v.linia = 2) linia_2 vehicles v group v.boczny; 

alternatively, put each linia on separate row:

select v.boczny, v.linia, count(*) vehicles v  group v.boczny, v.linia;