牛客963567466号

分类

/ 注册

全部文章（共30篇）

题解 | 返回购买价格为 10 美元或以上产品的顾客列表

select distinct cust_id from Orders where order_num in (select order_num from OrderItems where item_price >=10) ; 最好加个distinct，以免有一堆重复的用户id

2025-11-07

0 44

题解 | 返回订单数量总和不小于100的所有订单的订单号

select order_num from OrderItems group by order_num having sum(quantity)>=100 order by order_num; 要根据SQL执行顺序，不能用where，而是用having，分组后再筛选

2025-11-07

0 37

题解 | 每个供应商成本最低的产品

select vend_id,min(prod_price) cheapest_item from Products group by vend_id order by cheapest_item; group by执行顺序在select之前，所以会先按vend_id分组，再取最低的数字； ord...

2025-11-07

0 24

题解 | 确定 Products 表中价格不超过 10 美元的最贵产品的价格

select max(prod_price) as max_price from Products where prod_price<=10 where的执行顺序在select前

2025-11-06

0 42

题解 | 别名

select vend_id, vend_name vname,vend_address vaddress,vend_city vcity from Vendors order by vend_name; as 全省略了，asc也省了

2025-11-06

0 39

题解 | 纠错2

SELECT vend_name FROM Vendors WHERE vend_country = 'USA' AND vend_state = 'CA' ORDER BY vend_name ; where和order by 语句顺序反了

2025-11-06

0 44

题解 | 检查SQL语句

SELECT vend_name FROM Vendors ORDER by vend_name DESC; 有两处，第一句多了个逗号，第三句少了个by

2025-11-06

0 49

题解 | 从 Customers 表中检索所有的 ID

select cust_id from Customers C大写别忘了

2025-11-06

0 44

题解 | 每个月Top3的周杰伦歌曲

select * from( select month(fdate) as month, row_number()over(partition by month(fdate) order by count(s.song_name) desc,s.song_id)as ranking, song_n...

2025-11-06

0 31

题解 | 基本数学函数

select *, abs(value)absolute_value, ceiling(value)ceiling_value, floor(value)floor_value, round(value,1)rounded_value from numbers order by id; 都是基础的...

2025-11-06

0 34