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 阅读 ·
0 评论