携程9.30数分笔试第一题
各位大神好，
第一题我怎么都跑不过
代码如下
能问问跑出来的大神们要怎么写呢...那个精度我给跪了，不知道怎么搞出来，ROUND()也不行，cast也不行
select cast(avg_price as NUMERIC(10,4)) as avg_price,n.NAME as name from (
select avg(Price)avg_price,m.NAME as name from Products p
left join Manufacturers m
on m.CODE=p.Manufacturer
group by m.CODE,m.NAME
having avg(Price)>=120
order by NAME asc)n
select avg(Price)avg_price,m.NAME as name from Products p
left join Manufacturers m
on m.CODE=p.Manufacturer
group by m.CODE,m.NAME
having avg(Price)>=120
order by NAME asc)n
自己编译器是这样，但是题目后面有四个小数点，实在不知道怎么搞
投递携程等公司10个岗位 >