jjdhfbu

分类

/ 注册

全部文章（共44篇）

题解 | #插入记录（二）#

insert into exam_record_before_2021(uid,exam_id,start_time,submit_time,score) select uid,exam_id,start_time,submit_time,score from exam_record WHERE y...

2023-03-30

0 214

题解 | #插入记录（一）#

insert into exam_record (uid,exam_id,start_time,submit_time,score) values (1001,9001,'2021-09-01 22:11:12','2021-09-01 23:01:12',90), (1002,9002,'2021...

2023-03-29

0 228

题解 | #组合表#

select prod_name from Products union select cust_name as prod_name from Customers order by prod_name

2023-03-29

0 256

题解 | #将两个 SELECT 语句结合起来（二）#

select prod_id,quantity from OrderItems where quantity = "100" OR prod_id like "BNBG%" ORDER BY prod_id

2023-03-29

0 286

题解 | #将两个 SELECT 语句结合起来（一）#

select prod_id,quantity from OrderItems where quantity = "100" union select prod_id,quantity from OrderItems where prod_id like "BNBG%" 连接表，union，连接行

2023-03-29

0 220

题解 | #列出供应商及其可供产品的数量#

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

2023-03-29

0 244

题解 | #返回产品名称和每一项产品的总订单数#

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

2023-03-29

0 185

题解 | #确定最佳顾客的另一种方式（二）#

select c.cust_name, sum(oi.item_price*oi.quantity) as total_price from Orders as o inner join OrderItems as oi on o.order_num = oi.order_num inner jo...

2023-03-28

0 210

题解 | #返回购买 BR01 的所有顾客的电子邮件（二）#

select cust_email from Orders as o inner join OrderItems as oi on o.order_num = oi.order_num inner join Customers as c on o.cust_id = c.cust_id where ...

2023-03-28

0 206

题解 | #返回顾客名称和相关订单号以及每个订单的总价#

select c.cust_name,oi.order_num, sum(oi.quantity*oi.item_price) as OrderTotal from Orders as o left join OrderItems as oi on o.order_num = oi.order_nu...

2023-03-28

0 261