![](https://img-blog.csdnimg.cn/20190927151053287.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
MIT 6.830
文章平均质量分 63
记录一下学习MIT6.828课程时的学习心得
你回到了你的家
这个作者很懒,什么都没留下…
展开
-
SQLZOO 聚合操作
mysql 聚合操作原创 2022-06-07 23:47:07 · 74 阅读 · 0 评论 -
sql SELECT的嵌套使用介绍
1 数据集介绍https://sqlzoo.net/wiki/SELECT_within_SELECT_Tutorial依然是world表:2 习题及答案1SELECT name FROM world WHERE population > (SELECT population FROM world WHERE name='Russia')2select name from world where continent = 'Europe' and gdp/p原创 2022-05-27 21:49:41 · 2221 阅读 · 0 评论 -
sql select 基础用法
1 数据集介绍在线运行:https://sqlzoo.net/wiki/SELECT_basics2 练习题2.1 知识储备字符串需要使用单引号使用in可以检查某一项是否位于某个列表内使用between XXX and XXX可以检查某一项是否位于某个范围内2.2 练习show the population of Germanyselect population from world where name = 'Germany';Show the name and the po原创 2022-05-24 18:19:41 · 149 阅读 · 0 评论 -
sql SELECT LIKE介绍
1 数据集介绍本次仅需使用表world,表项如下:在线运行:https://sqlzoo.net/wiki/SELECT_names2 练习题2.1 知识储备The % is a wild-card it can match any characters2.2 问题Find the country that start with Yselect name from world where name like 'Y%';Find the countries that end wit原创 2022-05-23 22:07:18 · 445 阅读 · 0 评论 -
Problem Set 1
1 引言The purpose of this assignment is to give you hands-on experience with the SQL programming language. SQL is a declarative language in which you specify the data you want in terms of its properties. This assignment focuses on the SELECT subset of SQL,原创 2022-05-23 20:36:09 · 138 阅读 · 0 评论