select a.ptype, a.pname, a.pview, ifnull(b.sales, 0) as selas
      from test a
               left join test_sell b on a.pid = b.id
      order by a.ptype desc, a.pview DESC

 select ptype, sum(pview) / count(*) as avg_pview from test group by ptype

     select ptype,round(sum(selas) / count(*), 0) as avg_sales
      from (select a.ptype, a.pname, a.pview, ifnull(b.sales, 0) as selas
            from test a
                     left join test_sell b on a.pid = b.id
            order by a.ptype desc, a.pview DESC) a
      where a.selas > 0
      group by ptype

select a.ptype,pname,pview,avg_pview,(pview/avg_pview)*0.3,selas,avg_sales,(selas/avg_sales)*0.7,(pview/avg_pview)*0.3+(selas/avg_sales)*0.7
from (select a.ptype, a.pname, a.pview, ifnull(b.sales, 0) as selas
      from test a
               left join test_sell b on a.pid = b.id
      order by a.ptype desc, a.pview DESC) a,
     (
         select ptype, sum(pview) / count(*) as avg_pview from test group by ptype) b,
     (select ptype,round(sum(selas) / count(*), 1) as avg_sales
      from (select a.ptype, a.pname, a.pview, ifnull(b.sales, 0) as selas
            from test a
                     left join test_sell b on a.pid = b.id
            order by a.ptype desc, a.pview DESC) a
      where a.selas > 0
      group by ptype) c

where a.ptype = b.ptype
  and b.ptype = c.ptype order by a.ptype;