SELECT  calc_type,
        CASE WHEN DAYS IS NULL AND NON_NULL_RECORDS > (TOTAL_RECORDS)/2 THEN MAX(DAYS) OVER (PARTITION BY TO_CHAR(SELECTION_DATE,'yy"Q"q')ORDER BY NULL) ELSE DAYS END DAYS,
        contract_number,
        NTPACT,
        SELECTION_DATE,
        AMENDREQ,
        RECPROP,
        AMEND_STATUS_CODE,
        AMENDMENT_NUMBER,
        SELECTION_DATE AS PARAM_DATE,
        TO_CHAR(SELECTION_DATE,'yy"Q"q') quarter,
        T2.NULL_RECORDS,
        T2.NON_NULL_RECORDS,
        T2.TOTAL_RECORDS
FROM (SELECT DISTINCT ' Project Specific/Other' calc_Type
     ,TRUNC (NTPACT - Selection_Date) Days
     ,Contract_Number
     ,NTPACT
     ,SELECTION_DATE
     ,AMENDREQ
     ,RECPROP
     ,AMEND_STATUS_CODE
     ,AMENDMENT_NUMBER
     ,SELECTION_DATE AS PARAM_DATE
FROM contract_vw2

     WHERE ( Contract_Type = 'Project Specific' OR contract_type = 'Other')
     AND AMENDMENT_NUMBER=0
     AND AMEND_STATUS_CODE NOT IN (4,33,34,35,36,37))T1,
     (SELECT
      COUNT(*) AS TOTAL_RECORDS,
      SUM(CASE WHEN NTPACT IS NULL THEN 1 END) AS NULL_RECORDS,
      SUM(CASE WHEN NTPACT IS NOT NULL THEN 1 END) AS NON_NULL_RECORDS
      FROM contract_vw2
      WHERE ( Contract_Type = 'Project Specific' OR contract_type = 'Other')
      AND AMENDMENT_NUMBER=0
      AND AMEND_STATUS_CODE NOT IN (4,33,34,35,36,37)
      ) T2
	  
	 

create table test
(
id number,
name varchar2(20)
);

insert into test values(1,'Test1');
insert into test values(2,'Test2');