show tables

drop table RKMIXCALIB

create table RKMIXCALIB (MEASURMENT_MODEL 	varchar(32),
                         COLOR			varchar(32),
                         NUMBER			varchar(32),
                         DECK				DECIMAL(3),
                         FACE				varchar(32),
                         JOKER			varchar(32),
                         RED				DECIMAL(19),
                         GREEN			DECIMAL(19),
                         BLUE				DECIMAL(19),
                         STATUS			varchar(1024),
                         INFO1			varchar(1024),
                         INFO2			varchar(1024),
                         INFO3			varchar(1024))

select * from RKMIXCALIB

select face,avg(red+green+blue) from RKMIXCALIB where MEASURMENT_MODEL='MULTI_3'
  group by face 
