下表fruits是水果明细表，字段有f-id(水果编号)、s_id(供应商编号)、f_name(水果名称)、f_price(供货价格)。请回答下面的问题
(2)查询每个供应商价格最高的水果信息(暂不考虑f_price为null的情况)。以下代码不正确的是（ ）
A. select * from fruits where (s_id, f_price) in (select s_id, max(f_price) from fruits group by s_id);
B. select fruits.* from fruits left join (select s_id, max(f_price) from fruits group by s_id) as T where f_price=max(f_price);
C. select fruits.* from fruits inner join (select s_id, max(f_price) as maxprice from fruits group by s_id) as T where f_price=maxprice;
D. select * from (select *, max(f_price)over(partition by s_id) as maxprice from fruits) as T where f_price=maxprice;
