how to show certain row data from query horizontally in sql : i have this query 


     select inv.refe, co.color, inv.size, sum(acu.total), bo.wareh from inv_article inv 
    inner join inv_colors co on inv.color = co.color
    inner join inv_store acu on inv.item = acu.item 
    inner join inv_bods bo on bo.wareh = acu.wareh
    where refers = 'julios' 
    and acu.year = '2018'
    group by inv.refe, co.color, inv.size, bo.wareh
    having SUM(total) != '0'

which gives me the following result 



    > JULIOS	BLUE             	35  	1,00	DENVER      
    > JULIOS	BLUE             	35  	1,00	PA
    > JULIOS	BLUE             	36  	1,00	FLORIDA    
    > JULIOS	BLUE            	36  	2,00	FLORIDA
    > JULIOS	BLUE             	37  	2,00	HOUSTON
    > JULIOS	BLUE             	38  	2,00	FLORIDA
    > JULIOS	GREEN             	35  	1,00	DENVER      
    > JULIOS	GREEN             	35  	1,00	PA
    > JULIOS	GREEN             	36  	1,00	FLORIDA    
    > JULIOS	GREEN            	36  	2,00	FLORIDA
    > JULIOS	GREEN             	37  	2,00	HOUSTON
    > JULIOS	GREEN             	38  	2,00	FLORIDA

I WANT THE RESUL TO SHOW THE SIZE RESULT HORIZONTALLY EXAMPLE


refe         color   35  36  37  38  39  40  wareh

and the total goes on the bottom of each size 

              
