- 博客(8)
- 收藏
- 关注
RSS订阅原创 SQLZOO练习记录-NULL
目录Using NULLTeachers and DepartmentsUsing NULLTeachers and Departments1.List the teachers who have NULL for their department.SELECT nameFROM teacherWHERE dept IS NULL2.Note the INNER JOIN misses the teachers with no department and the depa
2020-09-19 17:34:31
184
原创 SQLZOO练习记录-JOIN
The JOIN operationJOIN and UEFA EURO 20121.Modify it to show thematchidandplayername for all goals scored by Germany.SELECT matchid, playerFROM goal WHERE teamid='GER'2.Show id, stadium, team1, team2 for just game 1012SELECT id, stadium,...
2020-09-16 23:17:40
380
原创 SQLZOO练习记录-SUM and COUNT
The nobel table can be used to practice more SUM and COUNT functions.1.Show the total number of prizes awarded.SELECT COUNT(winner) FROM nobel2.List each subject - just onceSELECT DISTINCT subject FROM nobel3.Show the total number of prizes a
2020-09-16 20:30:04
389
1
原创 OpenGL初探：二维卡通人物交互设计
使用OpenGL实现基于鼠标交互的卡通人物和其它环境物体的设计与绘制。使用颜色填充与反走样技术对卡通人物外貌以及衣着进行绘制。实现对卡通人物或物体轮廓的交互控制，点击鼠标左键可以对人物或者物体进行拖拽移动调整。按“↑”按键能够实现卡通人物绕坐标原点（或指定点）进行旋转，按“z”键可实现对选中的人物或者物体进行放缩。选中其中的一个多边形区域，点击鼠标右键，弹出一个菜单，可以对该区域进行不同颜色的选择。
2017-05-21 23:17:26
5135
1
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人