主观题:李白引用孟浩然的诗 - C/C++ 数据分析 - 唐代诗人的朋友圈*
在SQLiteStudio中执行下述复合SQL语句,查询李白引用孟浩然的所有诗。
SELECT * FROM poem
WHERE id IN
( SELECT poemid FROM reference
WHERE authorid IN
(SELECT id FROM poet WHERE name = '李白') AND
refid IN (SELECT id FROM poet WHERE name = '孟浩然')
);
提交一张JPG图片:
1. 执行结果的全屏截图;
2. 代码中合适位置以注释形式写上你的学号及姓名。
### 感觉不会? 那试着听听**免费的B站网课**
[简洁的C和C++ - 重庆大学在线课程](https://www.bilibili.com/video/BV1it411d7zx/)
[Python编程基础及应用 - 重庆大学在线课程](https://www.bilibili.com/video/BV1kt411R7uW/)

答案:
SELECT * FROM poem
WHERE id IN
( SELECT poemid FROM reference
WHERE authorid IN
(SELECT id FROM poet WHERE name = '李白') AND
refid IN (SELECT id FROM poet WHERE name = '孟浩然')
);
提交一张JPG图片:
1. 执行结果的全屏截图;
2. 代码中合适位置以注释形式写上你的学号及姓名。
### 感觉不会? 那试着听听**免费的B站网课**
[简洁的C和C++ - 重庆大学在线课程](https://www.bilibili.com/video/BV1it411d7zx/)
[Python编程基础及应用 - 重庆大学在线课程](https://www.bilibili.com/video/BV1kt411R7uW/)

答案: