SELECT, AVG, MIN - zapytanie SQL - pomocy

select top 1
   min(measurementQuantity) wynik
from (select 
        case 
            when measurementDate between '2019-07-01' and '2019-07-10' then 1
            when measurementDate between '2019-07-11' and '2019-07-20' then 2
            when measurementDate between '2019-07-21' and '2019-07-31' then 3
        end o
        ,* 
     from 
         tb) dt
 where 
    measurementQuantity > (select avg(measurementQuantity)*0.15 from tb where measurementQuantity>0)
group by
   o
 order by
    1 desc

const insertSql = `INSERT INTO detailsplan (
                idPoint,
                firstDegreeDay,
                secondDegreeDay,
                thirdDegreeDay,
                fourthDegreeDay,
                fifthDegreeDay,
                sixthDegreeDay,
                seventhDegreeDay,
                eighthDegreeDay,
                ninthDegreeDay,
                tenthDegreeDay,
                eleventhDegreeDay,
                twelfthDegreeDay)
                SELECT
                idPoint,
                contractedCapacity,
                AVG(NULLIF(measurementQuantity,0)),
                AVG(NULLIF(measurementQuantity,0))-(1*((AVG(NULLIF(measurementQuantity,0))-MIN(measurementQuantity))/8)),
                AVG(NULLIF(measurementQuantity,0))-(2*((AVG(NULLIF(measurementQuantity,0))-MIN(measurementQuantity))/8)),
                AVG(NULLIF(measurementQuantity,0))-(3*((AVG(NULLIF(measurementQuantity,0))-MIN(measurementQuantity))/8)),
                AVG(NULLIF(measurementQuantity,0))-(4*((AVG(NULLIF(measurementQuantity,0))-MIN(measurementQuantity))/8)),
                AVG(NULLIF(measurementQuantity,0))-(5*((AVG(NULLIF(measurementQuantity,0))-MIN(measurementQuantity))/8)),
                AVG(NULLIF(measurementQuantity,0))-(6*((AVG(NULLIF(measurementQuantity,0))-MIN(measurementQuantity))/8)),
                AVG(NULLIF(measurementQuantity,0))-(7*((AVG(NULLIF(measurementQuantity,0))-MIN(measurementQuantity))/8)),
                MIN(measurementQuantity),
                0,
                0}
                FROM measurementsdaily m WHERE m.measurementDate >= '${from}' AND m.measurementDate <= '${to}' GROUP BY idPoint`

select
   idPoint
   ,max(m) `tenthDegreeDay`
   ,max(case when o=3 then avg15 else 0 end) `secondDegreeDay`
FROM (
   SELECT 
      O
      ,idPoint
      ,avg15
      , min(`measurementQuantity`) m
   FROM (select 
          case  
             when day( `measurementDate`) > 20 then 3
             when day( `measurementDate`) > 10 then 2
             when day( `measurementDate`) > 0 then 1
         END O
         ,measurementDate
         ,mmd.idPoint
         ,contractedCapacity
         ,measurementQuantity
         ,avg15
       from 
          `measurementsdaily` mmd
          inner join (select 
                     idPoint
                     ,avg(measurementQuantity)*0.15 avg15 
                  from 
                     `measurementsdaily` 
                  where 
                     measurementQuantity>0 
                     and measurementDate between '2019-07-01' and '2019-07-31'
                  group by
                     idPoint
                  ) mmd_avg on mmd_avg.idPoint = mmd.idPoint
       where 
         measurementQuantity > avg15
           and measurementDate between '2019-07-01' and '2019-07-31') dt
   group by
      o
      ,idPoint
      ,avg15) r
group by
    idPoint

select
	idPoint
	,max(m) `tenthDegreeDay`
	,max(SDD) `secondDegreeDay`
FROM (
	SELECT 
		O
		,idPoint
		,avg15
		, min(`measurementQuantity`) m
		,sum(case when o=3 then measurementQuantity else null end)/sum(case when o=3 then 1 else null end) `SDD`
	FROM (select 
			 case  
				 when day( `measurementDate`) > 20 then 3
				 when day( `measurementDate`) > 10 then 2
				 when day( `measurementDate`) > 0 then 1
			END O
			,measurementDate
			,mmd.idPoint
			,contractedCapacity
			,measurementQuantity
			,avg15
		 from 
			 `measurementsdaily` mmd
			 inner join (select 
							idPoint
							,avg(measurementQuantity)*0.15 avg15 
						from 
							`measurementsdaily` 
						where 
							measurementQuantity>0 
							and measurementDate between '2019-07-01' and '2019-07-31'
						group by
							idPoint
						) mmd_avg on mmd_avg.idPoint = mmd.idPoint
		 where 
			measurementQuantity > avg15
     		and measurementDate between '2019-07-01' and '2019-07-31') dt
	group by
	   o
	   ,idPoint
	   ,avg15) r
group by
    idPoint

select
	idPoint
	,max(m) `tenthDegreeDay`
	,max(case when o=3 then avg15/0.15 else 0 end) `secondDegreeDay`
FROM (
	SELECT 
		O
		,idPoint
		,avg15
		, min(`measurementQuantity`) m
	FROM (select 
			 case  
				 when day( `measurementDate`) > 20 then 3
				 when day( `measurementDate`) > 10 then 2
				 when day( `measurementDate`) > 0 then 1
			END O
			,measurementDate
			,mmd.idPoint
			,contractedCapacity
			,measurementQuantity
			,avg15
		 from 
			 `measurementsdaily` mmd
			 inner join (select 
							idPoint
							,avg(measurementQuantity)*0.15 avg15 
						from 
							`measurementsdaily` 
						where 
							measurementQuantity>0 
							and measurementDate between '2019-07-21' and '2019-07-31'
						group by
							idPoint
						) mmd_avg on mmd_avg.idPoint = mmd.idPoint
		 where 
			measurementQuantity > avg15
     		and measurementDate between '2019-07-01' and '2019-07-31') dt
	group by
	   o
	   ,idPoint
	   ,avg15) r
group by
    idPoint