希望被offer砸中的红太狼很精致

分类

/ 注册

全部文章（共17篇）

题解 | #纠错4#

select * from (SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state = 'MI' UNION SELECT cust_name, cust_contact, cust_email ...

2023-07-08

0 297

题解

select * from ( select prod_id,quantity from OrderItems where quantity='100' union select prod_id,quantity from OrderItems where prod_id like 'BNBG%')...

2023-07-08

0 291

题解

select v.vend_id,count(p.prod_id) prod_id from Vendors v left join Products p on v.vend_id=p.vend_id group by v.vend_id order by v.vend_id

2023-07-08

0 302

题解

select p.prod_name,count(o.order_num) orders from Products p left join OrderItems o on p.prod_id=o.prod_id group by p.prod_name order by p.prod_name

2023-07-08

0 379

题解

select c.cust_name,o.order_num from Customers c left join Orders o on c.cust_id=o.cust_id order by c.cust_name

2023-07-08

0 286

题解

select c.cust_name cust_name,SUM(m.item_price*m.quantity) total_price from Orders o inner join Customers c on o.cust_id=c.cust_id inner join Order...

2023-07-08

2 395

题解

select o.cust_id cust_id,o.order_date order_date from OrderItems m,Orders o where m.order_num=o.order_num and m.prod_id ='BR01' order by order_date

2023-07-08

0 331