- 博客(2)
- 收藏
- 关注
原创 Self_join -SQLZOO - 练习答案
Self_join -SQLZOO 题目源自 : https://sqlzoo.net/wiki/Self_join 4 SELECT company, num, COUNT(*) FROM route WHERE stop=149 OR stop=53 GROUP BY company, num having count(*) =2 5 SELECT a.company, a.num, a.stop, b.stop FROM route a JOIN route b ON (a.company
2021-03-28 19:39:57
69
原创 SQLZOO - NSS_Tutorial
SQLZOO - NSS_Tutorial 1、Show the the percentage who STRONGLY AGREE SELECT A_STRONGLY_AGREE FROM nss WHERE question='Q01' AND institution='Edinburgh Napier University' AND subject='(8) Computer Science' 2、Show the institution and subject where the
2021-03-28 16:50:35
150
1
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人