OkMaid

题解

/ 注册

全部文章 / 题解（共33篇）

题解 | #更新记录（二）#

update exam_record set submit_time = '2099-01-01 00:00:00', score = 0 where start_time < '2021-09-01' and score is null

Mysql

2022-06-04

0 274

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

```REPLACE INTO examination_info VALUES(NULL,9003,'SQL','hard',90,'2021-01-01 00:00:00');

Mysql

2022-05-31

0 279

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

``insert into exam_record_before_2021 (uid, exam_id, start_time, submit_ti...

Mysql

2022-05-31

0 293

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

```select prod_id, quantity from OrderItems where quantity = 100 or prod_id Like 'BNBG%'

Mysql

2022-05-30

0 450

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

```select prod_id,quantity from OrderItems where quantity=100 union select prod_id,quantity from OrderItems where prod_id like 'BNBG%' order by prod_...

Mysql

2022-05-30

0 300

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

```select v.vend_id, count(prod_id) from Products p right join Vendors v on p.vend_id = v.vend_id group by vend_id order by vend_id v.vend_id代表所有供应...

Mysql

2022-05-30

0 308

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

``select prod_name, count(order_num) as orders from Products p left join OrderItems oi on p.prod_id = oi.prod_id group b...

Mysql

2022-05-30

0 261

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

```select c.cust_name, ois.total_price from Customers c join Orders o on c.cust_id = o.cust_id join (select order_num, sum(item_price * quantity) as t...

Mysql

2022-05-29

0 294

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

select cust_name, t1.order_num, oi.OrderTotal from Customers join Orders t1 using(cust_id) join (select&n...

Mysql

2022-05-28

0 275

题解 | #返回每个顾客不同订单的总金额#

select o.cust_id, oi.total_ordered from Orders o join (select os.order_num, sum(item_price * q...

Mysql

2022-05-28

0 233