ROUND(SUM(
							CASE WHEN dif =0 THEN  
							pow(2, (20 - 16))
							WHEN dif <>0 THEN dif END
					) / count_all, 2)::numeric

SELECT id, username, password, 
        ( SELECT COUNT(id) FROM sh WHERE username = w.username AND time > (NOW() - '600 SECOND'::INTERVAL) ) AS count_all,
       ( SELECT COUNT(id) FROM sh_a WHERE username = w.username AND time >  (NOW() - '600 SECOND'::INTERVAL) ) AS count_all_archive,
       (
         SELECT
                NULLIF(
				CASE WHEN our_result='Y' THEN  
					ROUND(SUM(
							CASE WHEN dif =0 THEN  
							pow(2, (20 - 16))
							WHEN dif <>0 THEN dif END
					) * POW(2, 16) / 600 / 1000)::numeric
				WHEN our_result<>'Y' THEN 0 END
		  , 0) AS hashrate
          FROM sh
          WHERE
            username = w.username
          AND time > (NOW() - '600 SECOND'::INTERVAL)
		   GROUP BY our_result
      ) + (
        SELECT
          NULLIF(
				CASE WHEN our_result='Y' THEN  
					ROUND(SUM(
							CASE WHEN dif =0 THEN  
							pow(2, (20 - 16))
							WHEN dif <>0 THEN dif END
					) * POW(2, 16) / 600 / 1000)::numeric
				WHEN our_result<>'Y' THEN 0 END
		  , 0) 
		  AS hashrate
          FROM sh_a
          WHERE
            username = w.username
          AND time > (NOW() - '600 SECOND'::INTERVAL)
		  GROUP BY our_result
      ) AS hashrate,
      (
        SELECT dif
        FROM sh
        WHERE username = w.username AND time > (NOW() - '600 SECOND'::INTERVAL )
      ) + (
        SELECT 
		
			NULLIF(
				ROUND(SUM(
							CASE WHEN dif =0 THEN  
							pow(2, (20 - 16))
							WHEN dif <>0 THEN dif END
					) / count_all, 2)::numeric
		  , 0) 			
        FROM sh_a
        WHERE username = w.username AND time > ( NOW() - '600 SECOND'::INTERVAL )
      ) AS dif
       
      FROM p_w AS w
      WHERE account_id = '1'