阿莉勒丝黛拉

分类

题解(169)

/ 注册

全部文章（共162篇）

题解 | #查找后多列排序#

SELECT device_id, gpa, age FROM user_profile ORDER&nbs...

Mysql

2022-03-03

7 2436

题解 | #查找后排序#

SELECT device_id, age FROM user_profile ORDER BY ...

Mysql

2022-03-03

13 2670

题解 | #按照数量和价格排序#

SELECT quantity, item_price FROM OrderItems ORDER BY &n...

Mysql

2022-03-03

3 1032

题解 | #对顾客ID和日期排序#

SELECT cust_id, order_num FROM Orders ORDER BY cu...

Mysql

2022-03-03

39 4272

题解 | #检索顾客名称并且排序#

SELECT cust_name FROM Customers ORDER BY cust_name DESC;

Mysql

2022-03-03

24 1879

题解 | #计算用户8月每天的练题数量#

SELECT DAY(DATE) day, COUNT(question_id) question_cnt FROM question_...

Mysql

2022-03-03

1 377

题解 | #查看不同年龄段的用户明细#

SELECT device_id, gender, CASE WHEN age <...

Mysql

2022-03-03

1 315

题解 | #计算25岁以上和以下的用户数量#

SELECT CASE WHEN age >= 25 THEN '25岁及以上' ELSE ...

Mysql

2022-03-03

2 381

题解 | #统计每个学校的答过题的用户的平均答题数#

SELECT up.university university, COUNT(qpd.question_id) / COUNT(DISTINCT qpd.devic...

Mysql

2022-03-02

1 363

题解 | #浙江大学用户题目回答情况#

SELECT qpd.device_id device_id, qpd.question_id question_id, qpd.result result FROM question_p...

Mysql

2022-03-02

2 290