Выборка из нескольких таблиц

SELECT c_name, COUNT(*) cnt, 
FROM ( 
SELECT q.id, q.c_in_time, q.c_st, a.c_name 
FROM   qry_queue q, 
       qry_type t, 
       st_abonents a 
WHERE a.c_qry_type = t.id 
  AND t.c_ab_ref = a.id 
  AND (q.c_in_time - trunc(q.c_in_time)) BETWEEN 3/8 AND 3/4
) GROUP BY c_name
ORDER BY c_name;

SELECT type_id, MAX(type_name) type_name, 
       COUNT(DISTINCT CASE WHEN c_st=1 THEN id ELSE NULL END) cnt_suqsess,      --  успешно
       COUNT(DISTINCT CASE WHEN c_st=0 THEN id ELSE NULL END) cnt_error,        --  с ошибкой
       COUNT(DISTINCT CASE WHEN c_st IS NULL THEN id ELSE NULL END) cnt_fail    --  не обработано
       COUNT(*) cnt_all              -- все
FROM (
SELECT q.id, q.c_st, 
       t.c_name type_name         -- это тоже алиас
       t.id type_id               -- это тоже алиас
FROM qry_queue q,
     qry_type  t
WHERE q.c_qry_type = t.id
) GROUP BY type_id
   HAVING COUNT(DISTINCT CASE WHEN c_st=0 THEN id ELSE NULL END)/COUNT(*) > 0.05
ORDER BY type_name;

SELECT type_id, type_name FROM (
SELECT type_id, MAX(type_name) type_name, 
       COUNT(DISTINCT CASE WHEN c_st=1 THEN id ELSE NULL END) cnt_suqsess,      --  успешно
       COUNT(DISTINCT CASE WHEN c_st=0 THEN id ELSE NULL END) cnt_error,        --  с ошибкой
       COUNT(DISTINCT CASE WHEN c_st IS NULL THEN id ELSE NULL END) cnt_fail    --  не обработано
       COUNT(*) cnt_all              -- все
FROM (
SELECT q.id, q.c_st, 
       t.c_name type_name         -- это тоже алиас
       t.id type_id               -- это тоже алиас
FROM qry_queue q,
     qry_type  t
WHERE q.c_qry_type = t.id
) GROUP BY type_id
) WHERE  CASE WHEN cnt_error+cnt_suqsess = 0 THEN  0  -- или 1, в зависимости от того, как мы интерпретируем этот случай
       ELSE  cnt_error/(cnt_error+cnt_suqsess)  END  > 0.05
ORDER BY type_name;

SELECT nn, c_name, cnt 
FROM (
SELECT c_name, COUNT(*) cnt,
       ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC) nn
FROM (
SELECT q.id, q.c_exec_tyme, q.c_st, a.c_name
FROM qry_queue q,
     qry_type  t,
     st_abonents a
WHERE q.c_qry_type = t.id
  AND t.c_ab_ref  = a.id 
) GROUP BY c_name
) WHERE nn <=3
ORDER BY nn;