(select acct.cmpcode,count(LCODE) from ACCT group by acct.cmpcode) as logar,(select count(LCODE) from ACCT where ISTRN = 1 ) as log_kinoum,(select count(ARTID) from arts ) as arthra_eggrafes,(select count(DISTINCT custid) from arts ) as syn_pou_kinith,(select count(DISTINCT trns.LCODE) log_pou_kinithikan from trns ,arts where arts.artid=trns.artid and arts.cmpcode=trns.cmpcode ) as logar_pou_kinith

I want each row to start with the acct.cmpcode and then the counts for each one ! How can i DO THIS ??