求一个简单的SQL语句

select a.p_name,b.c_name,c.p_count,d.p_sum
from p_info a,c_info b,sale_info c,(select p_code,sum(p_count) p_sum from p_code group by p_code) d
where a.p_code = c.p_code
and b.c_code = c.c_code
and c.p_code = d.p_code

SELECT p_info.p_name, c_info.c_name, sale_info.p_count
FROM (p_info INNER JOIN sale_info ON p_info.p_code = sale_info.p_code) INNER JOIN c_info ON sale_info.c_code = c_info.c_code;

with t1 as(
select B.p_name,C.c_name,SUM(A.p_count) total_count1
from sale_info A
join p_info B on A.p_code= B.p_code
join c_info C on A.c_code=C.c_code
group by B.p_name
),t2 as(
select B.p_name,SUM(A.p_count) total_count2
from sale_info A
join p_info B on A.p_code= B.p_code
group by B.p_name
) select t1.*,t2.total_count2 from t1 join t2 on t1.p_name = t2.p_name

select a.p_name as '产品名称',b.c_name as '厂家名称',c.p_count as '销售数量'
from 第三个表名 c
left join 第二个表名 b o