阿莉勒丝黛拉

分类

题解(169)

/ 注册

全部文章（共128篇）

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

UPDATE examination_info SET tag = 'Python' WHERE tag = 'PYTHON';

Mysql

2022-03-10

1 337

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

REPLACE INTO examination_info (exam_id, tag, difficulty, duration, release_time) VALUES (9003, 'SQ...

Mysql

2022-03-10

1 318

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

INSERT INTO exam_record_before_2021 (uid, exam_id, start_time, submit_time, score) SELECT uid, &...

Mysql

2022-03-10

6 496

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

INSERT INTO exam_record (id, uid, exam_id, start_time, submit_time, score) VALUES ( &...

Mysql

2022-03-10

1 357

题解 | #浙大不同难度题目的正确率#

SELECT qd.difficult_level difficult_level, AVG(IF(qpd.result = 'right', 1, 0)) correct_rate FROM...

Mysql

2022-03-09

1 276

题解 | #统计复旦用户8月练题情况#

SELECT up.device_id device_id, up.university university, COUNT(qpd.question_id) question_cnt, ...

Mysql

2022-03-09

1 238

题解 | #纠错4#

SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state = 'MI...

Mysql

2022-03-09

1 331

题解 | #组合 Products 表中的产品名称和 Customers 表中的顾客名称#

SELECT prod_name FROM Products UNION ALL SELECT cust_name prod_name FROM Customers ORDER&nbs...

Mysql

2022-03-09

1 541

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

SELECT prod_id, quantity FROM OrderItems WHERE quantity = 100 OR prod_id LIKE 'BNBG%' ORDER BY prod_id;

Mysql

2022-03-09

7 1558

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

SELECT prod_id, quantity FROM OrderItems WHERE quantity = 100 UNION ALL SELECT prod_id, quantity FROM ...

Mysql

2022-03-09

4 1262