|
SELECT bolge.bolge_adı, arıza_mudahale_suresi.olusma_tarihi, vardiya_saati.vardiya_saati, Count(is_emri_no) AS sayi, Sum(arıza_mudahale_suresi.ustlenme) AS ustlenme_t, Sum(arıza_mudahale_suresi.ulasma) AS ulasma_t, Sum(arıza_mudahale_suresi.mudahale) AS mudahale_t, Sum(arıza_mudahale_suresi.kapatma) AS kapatma_t, Round((ustlenme_t/sayi),2) AS ustlenme_y, Round((ulasma_t/sayi),2) AS ulasma_y, Round((mudahale_t/sayi),2) AS mudahale_y, Round((kapatma_t/sayi),2) AS kapatma_y
|