缺少了gender列，可以调整一下。

关于level16的独特解法。
-- 请在此处输入 SQL
-- select sum(score) total_score,avg(score) avg_score,max(score) max_score,min(score) min_score from student

select 3073 as total_score,307.3 as avg_score ,600 as max_score ,0 as min_score

hhhh~~

hhh

一不小心点了刷新就得重头再来。。。

https://www.xue-sql.online/
https://v2ex.com/t/1011018

exam_num 的意义建议改得更加清晰，我理解为班级里这个人考了exam_num次

摸鱼fish年龄未知，不应归类为小同学

示例的查询结果和SQL代码好像不太匹配？
如果按照示例的SQL代码，跑一遍出来的结果应该是
+----------+--------+------------+---------+
| emp_name | salary | department | manager |
+----------+--------+------------+---------+
| 小明 | 5000 | 技术部 | 张三 |
| 小明 | 5000 | 技术部 | 李四 |
| 小明 | 5000 | 技术部 | 王五 |
| 李华 | 4500 | 销售部 | 张三 |
| 李华 | 4500 | 销售部 | 李四 |
| 李华 | 4500 | 销售部 | 王五 |
| 鸡哥 | 6000 | 财务部 | 张三 |
| 鸡哥 | 6000 | 财务部 | 李四 |
| 鸡哥 | 6000 | 财务部 | 王五 |
+----------+--------+------------+---------+
但这个和示例给出的结果不太相同，如果把SQL语句改成
mysql> select e.emp_name, e.salary, d.department, d.manager
-> from employees e, departments d
-> order by emp_name asc;
这样出来的结果是
+----------+--------+------------+---------+
| emp_name | salary | department | manager |
+----------+--------+------------+---------+
| 小明 | 5000 | 技术部 | 张三 |
| 小明 | 5000 | 财务部 | 李四 |
| 小明 | 5000 | 销售部 | 王五 |
| 李华 | 4500 | 技术部 | 张三 |
| 李华 | 4500 | 财务部 | 李四 |
| 李华 | 4500 | 销售部 | 王五 |
| 鸡哥 | 6000 | 技术部 | 张三 |
| 鸡哥 | 6000 | 财务部 | 李四 |
| 鸡哥 | 6000 | 销售部 | 王五 |
+----------+--------+------------+---------+
这样就和示例的结果相同了
所以问题应该是department的归属问题？

题目只要求查平均成绩，答案还查了对应id

输入的是答案也提示这个 语句错误，Cannot read properties of undefined (reading 'exec')

服务器拉取文件，然后运行提示：
VITE v3.2.7 ready in 1373 ms

➜ Local: http://localhost:5173/
➜ Network: use --host to expose

但是ip加端口无法访问，端口也放行了，但是端口并没有被占用...

结果

环境

Macbook air m2
macOS Sonoma 14.0 23A5312d arm64
node v20.5.1
npm 9.8.0

> npm list
[email protected] /Users/equationzhao/sql-mother
├── @bytemd/[email protected]
├── @bytemd/[email protected]
├── @bytemd/[email protected]
├── @types/[email protected]
├── @typescript-eslint/[email protected]
├── @typescript-eslint/[email protected]
├── @vitejs/[email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
└── [email protected]

SELECT adventurer_id, adventurer_name, SUM(reward_coins) AS total_reward_coins FROM rewards GROUP BY adventurer_id, adventurer_name ORDER BY total_reward_coins DESC LIMIT 3;

只 group by adventurer_id 也对🐔

看示例代码的时候，发现示例给的代码是跑不出来的。是否存在错误？
以下是我自己测试可以运行的代码
-- Level 23

-- My Answer of Example:
-- 主查询
SELECT c.name, o.total_amount
FROM customers c
INNER JOIN orders o ON c.customer_id = o.customer_id
WHERE c.customer_id IN (
	-- 子查询
	SELECT customer_id 
	FROM orders
	WHERE total_amount > 200
)

====================
-- Level 24

-- 主查询
SELECT c.name, o.total_amount
FROM customers c
INNER JOIN orders o ON c.customer_id = o.customer_id
WHERE EXISTS (
	-- 子查询
	SELECT DISTINCT customer_id
	FROM orders
)

我按照文档里写的，下载了代码，且 npm install了依赖，然后 npm run dev，发现报错了。

这是啥原因啊。

answer is ：select s.name student_name, s.age student_age, s.class_id class_id, c.name class_name from student s, class c;
并未用到cross join

请问网站的icon是我坤坤的头发吗

• reproduce: from websiite 31 ,enter level 31 to ∞，pages only Bogged down on the first page

• link :http://sqlmother.yupi.icu/#/learn/level31

22100f3
麻烦鱼皮看看可以不，可以的话我提 PR
好像 tab 格式不太一样，看看要不要改

Cannot read properties of undefined (reading 'exec')

例如新增了一个时间处理的自定义关卡，如果在里面新增多个子关卡？

题目要求将学生表和班级表的所有行组合在一起，并返回学生姓名（student_name）、学生年龄（student_age）、班级编号（class_id）以及班级名称（class_name）。

提供的答案是 select s.name student_name, s.age student_age, s.class_id class_id, c.name class_name from student s, class c;

因为 class 表里同样有 id 字段，表示班级编号，将 s.class_id class_id 改为 c.id class_id 之后满足题目的要求，但查询结果与答案不一致，无法通过关卡。

请问该练习网站的数据库是什么?

select datetime() as 'datetime'

在 http://sqlmother.yupi.icu/#/learn 上面运行没有问题,

在我本地 mysql:5.7.36 上面执行报错,提示

select datetime() as 'datetime'
> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '() as 'datetime'' at line 6
> Time: 0.001s

而换成

select CURRENT_TIMESTAMP as 'datetime';

则可以得的到期待的

l would like to help and offer my best knowledge to this comminity support request.
For more details visit https://mintycode.io

level18：

level19：

更加系统性地深入学习sql

第20关讲解示例中，员工表employees与部门表departments关联查询结果错误

SELECT e.emp_name, e.salary, e.department, d.manager
FROM employees e
CROSS JOIN departments d;

中e.department应更正为d.department

有一个记录的age是空的但是查询出来确实小同学 答案是否不正确

看答案中group_by adventurer_id,adventurer_name。但是adventurer_id已经是用户的唯一标识了，所以group_by adventurer_id应该就够了，没必要再加上adventurer_name了吧？

报错什么原因

介绍“分配唯一连续排名”，介绍中却没有给出并列的例子。

许多关卡的初始化SQL建表全和第一关一样，是要自己在本地编写每一关的createTable.sql，然后再本地运行吗？

添加这个功能后，用户可以在issue或者社区自定义关卡交流学习

1

failed to load config from C:\Users\LiWeiJun\Desktop\sql-mother-master\vite.config.ts
error when starting dev server:
Error:
You installed esbuild for another platform than the one you're currently using.
This won't work because esbuild is written with native code and needs to
install a platform-specific binary executable.

Specifically the "esbuild-windows-64" package is present but this platform
needs the "esbuild-windows-32" package instead. People often get into this
situation by installing esbuild on Windows or macOS and copying "node_modules"
into a Docker image that runs Linux, or by copying "node_modules" between
Windows and WSL environments.

If you are installing with npm, you can try not copying the "node_modules"
directory when you copy the files over, and running "npm ci" or "npm install"
on the destination platform after the copy. Or you could consider using yarn
instead of npm which has built-in support for installing a package on multiple
platforms simultaneously.

If you are installing with yarn, you can try listing both this platform and the
other platform in your ".yarnrc.yml" file using the "supportedArchitectures"
feature: https://yarnpkg.com/configuration/yarnrc/#supportedArchitectures
Keep in mind that this means multiple copies of esbuild will be present.

Another alternative is to use the "esbuild-wasm" package instead, which works
the same way on all platforms. But it comes with a heavy performance cost and
can sometimes be 10x slower than the "esbuild" package, so you may also not
want to do that.

at generateBinPath (C:\Users\LiWeiJun\Desktop\sql-mother-master\node_modules\esbuild\lib\main.js:1808:17)
at esbuildCommandAndArgs (C:\Users\LiWeiJun\Desktop\sql-mother-master\node_modules\esbuild\lib\main.js:1886:33)
at ensureServiceIsRunning (C:\Users\LiWeiJun\Desktop\sql-mother-master\node_modules\esbuild\lib\main.js:2051:25)
at build (C:\Users\LiWeiJun\Desktop\sql-mother-master\node_modules\esbuild\lib\main.js:1942:26)
at bundleConfigFile (file:///C:/Users/LiWeiJun/Desktop/sql-mother-master/node_modules/vite/dist/node/chunks/dep-2faf2534.js:63043:26)
at loadConfigFromFile (file:///C:/Users/LiWeiJun/Desktop/sql-mother-master/node_modules/vite/dist/node/chunks/dep-2faf2534.js:63019:31)
at resolveConfig (file:///C:/Users/LiWeiJun/Desktop/sql-mother-master/node_modules/vite/dist/node/chunks/dep-2faf2534.js:62643:34)
at createServer (file:///C:/Users/LiWeiJun/Desktop/sql-mother-master/node_modules/vite/dist/node/chunks/dep-2faf2534.js:61943:26)
at CAC.<anonymous> (file:///C:/Users/LiWeiJun/Desktop/sql-mother-master/node_modules/vite/dist/node/cli.js:707:30)

可以增加SQLAlchemy 的练习吗？谢谢了

• reproduce:已完成当前题目之后9，点击下一关进去到10，然后跳转回到当前的题目9，仍然需要重新答题才能进入10.
• link: http://sqlmother.yupi.icu/#/learn/level9.