René's URL Explorer Experiment

Title: GitHub - ZeroAC/databaseExam: 长沙理工研究生高级数据库作业 · GitHub

Open Graph Title: GitHub - ZeroAC/databaseExam: 长沙理工研究生高级数据库作业

X Title: GitHub - ZeroAC/databaseExam: 长沙理工研究生高级数据库作业

Description: 长沙理工研究生高级数据库作业. Contribute to ZeroAC/databaseExam development by creating an account on GitHub.

Open Graph Description: 长沙理工研究生高级数据库作业. Contribute to ZeroAC/databaseExam development by creating an account on GitHub.

X Description: 长沙理工研究生高级数据库作业. Contribute to ZeroAC/databaseExam development by creating an account on GitHub.

Opengraph URL: https://github.com/ZeroAC/databaseExam

X: @github

direct link

Domain: github.com

route-pattern	/:user_id/:repository
route-controller	files
route-action	disambiguate
fetch-nonce	v2:0719ae20-8ef9-b525-84c5-9bacafaea1f8
current-catalog-service-hash	f3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-id	B096:D440C:3210058:45A974F:6A634692
html-safe-nonce	330c8ff804849da13910558825098f77224edb8c88bace09118c668774ba46cf
visitor-payload	eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCMDk2OkQ0NDBDOjMyMTAwNTg6NDVBOTc0Rjo2QTYzNDY5MiIsInZpc2l0b3JfaWQiOiIxODkxNTc4NDUxNjMzMzI1NzE0IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac	e8db404e9c988a0a2af587f421c90234c2572aed310734b45826c63ade41ecd4
hovercard-subject-tag	repository:365969303
github-keyboard-shortcuts	repository,copilot
google-site-verification	Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-url	https://collector.github.com/github/collect
analytics-location	//
fb:app_id	1401488693436528
apple-itunes-app	app-id=1477376905, app-argument=https://github.com/ZeroAC/databaseExam
twitter:image	https://opengraph.githubassets.com/2ffca69fb74566f9874094845940b335371aa053d94b81a11658c647dec425e1/ZeroAC/databaseExam
twitter:card	summary_large_image
og:image	https://opengraph.githubassets.com/2ffca69fb74566f9874094845940b335371aa053d94b81a11658c647dec425e1/ZeroAC/databaseExam
og:image:alt	长沙理工研究生高级数据库作业. Contribute to ZeroAC/databaseExam development by creating an account on GitHub.
og:image:width	1200
og:image:height	600
og:site_name	GitHub
og:type	object
hostname	github.com
expected-hostname	github.com
None	59e55daad7174ca59d63c6974d58276ccb5477442e550bebb3c035e1bef11c94
turbo-cache-control	no-cache
go-import	github.com/ZeroAC/databaseExam git https://github.com/ZeroAC/databaseExam.git
octolytics-dimension-user_id	48408574
octolytics-dimension-user_login	ZeroAC
octolytics-dimension-repository_id	365969303
octolytics-dimension-repository_nwo	ZeroAC/databaseExam
octolytics-dimension-repository_public	true
octolytics-dimension-repository_is_fork	false
octolytics-dimension-repository_network_root_id	365969303
octolytics-dimension-repository_network_root_nwo	ZeroAC/databaseExam
turbo-body-classes	logged-out env-production page-responsive
disable-turbo	false
browser-stats-url	https://api.github.com/_private/browser/stats
browser-errors-url	https://api.github.com/_private/browser/errors
release	990295d92a4cc7b63fbbd83a046217cd7d77d49c
ui-target	full
theme-color	#1e2327
color-scheme	light dark

Links:

Skip to content	https://github.com/ZeroAC/databaseExam#start-of-content
	https://github.com/
Sign in	https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FZeroAC%2FdatabaseExam
GitHub CopilotWrite better code with AI	https://github.com/features/copilot
GitHub Copilot appDirect agents from issue to merge	https://github.com/features/ai/github-app
MCP RegistryNewIntegrate external tools	https://github.com/mcp
ActionsAutomate any workflow	https://github.com/features/actions
CodespacesInstant dev environments	https://github.com/features/codespaces
IssuesPlan and track work	https://github.com/features/issues
Code ReviewManage code changes	https://github.com/features/code-review
Code QualityEnforce quality at merge	https://github.com/features/code-quality
GitHub Advanced SecurityFind and fix vulnerabilities	https://github.com/security/advanced-security
Code securitySecure your code as you build	https://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they start	https://github.com/security/advanced-security/secret-protection
Why GitHub	https://github.com/why-github
Documentation	https://docs.github.com
Blog	https://github.blog
Changelog	https://github.blog/changelog
Marketplace	https://github.com/marketplace
View all features	https://github.com/features
Enterprises	https://github.com/enterprise
Small and medium teams	https://github.com/team
Startups	https://github.com/enterprise/startups
Nonprofits	https://github.com/solutions/industry/nonprofits
App Modernization	https://github.com/solutions/use-case/app-modernization
DevSecOps	https://github.com/solutions/use-case/devsecops
DevOps	https://github.com/solutions/use-case/devops
CI/CD	https://github.com/solutions/use-case/ci-cd
View all use cases	https://github.com/solutions/use-case
Healthcare	https://github.com/solutions/industry/healthcare
Financial services	https://github.com/solutions/industry/financial-services
Manufacturing	https://github.com/solutions/industry/manufacturing
Government	https://github.com/solutions/industry/government
View all industries	https://github.com/solutions/industry
View all solutions	https://github.com/solutions
AI	https://github.com/resources/articles?topic=ai
Software Development	https://github.com/resources/articles?topic=software-development
DevOps	https://github.com/resources/articles?topic=devops
Security	https://github.com/resources/articles?topic=security
View all topics	https://github.com/resources/articles
Customer stories	https://github.com/customer-stories
Events & webinars	https://github.com/resources/events
Ebooks & reports	https://github.com/resources/whitepapers
Business insights	https://github.com/solutions/executive-insights
GitHub Skills	https://skills.github.com
Documentation	https://docs.github.com
Customer support	https://support.github.com
Community forum	https://github.com/orgs/community/discussions
Trust center	https://github.com/trust-center
Partners	https://github.com/partners
View all resources	https://github.com/resources
GitHub SponsorsFund open source developers	https://github.com/open-source/sponsors
Security Lab	https://securitylab.github.com
Maintainer Community	https://maintainers.github.com
Accelerator	https://github.com/open-source/accelerator
GitHub Stars	https://stars.github.com
Archive Program	https://archiveprogram.github.com
Topics	https://github.com/topics
Trending	https://github.com/trending
Collections	https://github.com/collections
Enterprise platformAI-powered developer platform	https://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security features	https://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI features	https://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 support	https://github.com/enterprise/premium-support
Pricing	https://github.com/pricing
Search syntax tips	https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentation	https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in	https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FZeroAC%2FdatabaseExam
Sign up	https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E&source=header-repo&source_repo=ZeroAC%2FdatabaseExam
Reload	https://github.com/ZeroAC/databaseExam
Reload	https://github.com/ZeroAC/databaseExam
Reload	https://github.com/ZeroAC/databaseExam
ZeroAC	https://github.com/ZeroAC
databaseExam	https://github.com/ZeroAC/databaseExam
Notifications	https://github.com/login?return_to=%2FZeroAC%2FdatabaseExam
Fork 0	https://github.com/login?return_to=%2FZeroAC%2FdatabaseExam
Star 1	https://github.com/login?return_to=%2FZeroAC%2FdatabaseExam
Code	https://github.com/ZeroAC/databaseExam
Issues 0	https://github.com/ZeroAC/databaseExam/issues
Pull requests 0	https://github.com/ZeroAC/databaseExam/pulls
Actions	https://github.com/ZeroAC/databaseExam/actions
Projects	https://github.com/ZeroAC/databaseExam/projects
Security and quality 0	https://github.com/ZeroAC/databaseExam/security
Insights	https://github.com/ZeroAC/databaseExam/pulse
Code	https://github.com/ZeroAC/databaseExam
Issues	https://github.com/ZeroAC/databaseExam/issues
Pull requests	https://github.com/ZeroAC/databaseExam/pulls
Actions	https://github.com/ZeroAC/databaseExam/actions
Projects	https://github.com/ZeroAC/databaseExam/projects
Security and quality	https://github.com/ZeroAC/databaseExam/security
Insights	https://github.com/ZeroAC/databaseExam/pulse
	https://github.com/ZeroAC/databaseExam
Branches	https://github.com/ZeroAC/databaseExam/branches
Tags	https://github.com/ZeroAC/databaseExam/tags
	https://github.com/ZeroAC/databaseExam/branches
	https://github.com/ZeroAC/databaseExam/tags
9 Commits	https://github.com/ZeroAC/databaseExam/commits/main/
	https://github.com/ZeroAC/databaseExam/commits/main/
01.sql	https://github.com/ZeroAC/databaseExam/blob/main/01.sql
01.sql	https://github.com/ZeroAC/databaseExam/blob/main/01.sql
02.sql	https://github.com/ZeroAC/databaseExam/blob/main/02.sql
02.sql	https://github.com/ZeroAC/databaseExam/blob/main/02.sql
03.sql	https://github.com/ZeroAC/databaseExam/blob/main/03.sql
03.sql	https://github.com/ZeroAC/databaseExam/blob/main/03.sql
04.sql	https://github.com/ZeroAC/databaseExam/blob/main/04.sql
04.sql	https://github.com/ZeroAC/databaseExam/blob/main/04.sql
05.sql	https://github.com/ZeroAC/databaseExam/blob/main/05.sql
05.sql	https://github.com/ZeroAC/databaseExam/blob/main/05.sql
06.sql	https://github.com/ZeroAC/databaseExam/blob/main/06.sql
06.sql	https://github.com/ZeroAC/databaseExam/blob/main/06.sql
07.sql	https://github.com/ZeroAC/databaseExam/blob/main/07.sql
07.sql	https://github.com/ZeroAC/databaseExam/blob/main/07.sql
README.md	https://github.com/ZeroAC/databaseExam/blob/main/README.md
README.md	https://github.com/ZeroAC/databaseExam/blob/main/README.md
README.pdf	https://github.com/ZeroAC/databaseExam/blob/main/README.pdf
README.pdf	https://github.com/ZeroAC/databaseExam/blob/main/README.pdf
allDataBases.sql	https://github.com/ZeroAC/databaseExam/blob/main/allDataBases.sql
allDataBases.sql	https://github.com/ZeroAC/databaseExam/blob/main/allDataBases.sql
before04.sql	https://github.com/ZeroAC/databaseExam/blob/main/before04.sql
before04.sql	https://github.com/ZeroAC/databaseExam/blob/main/before04.sql
jx_tb1.sql	https://github.com/ZeroAC/databaseExam/blob/main/jx_tb1.sql
jx_tb1.sql	https://github.com/ZeroAC/databaseExam/blob/main/jx_tb1.sql
jxsk.mwb	https://github.com/ZeroAC/databaseExam/blob/main/jxsk.mwb
jxsk.mwb	https://github.com/ZeroAC/databaseExam/blob/main/jxsk.mwb
model.mwb	https://github.com/ZeroAC/databaseExam/blob/main/model.mwb
model.mwb	https://github.com/ZeroAC/databaseExam/blob/main/model.mwb
model.mwb.bak	https://github.com/ZeroAC/databaseExam/blob/main/model.mwb.bak
model.mwb.bak	https://github.com/ZeroAC/databaseExam/blob/main/model.mwb.bak
transaction.sql	https://github.com/ZeroAC/databaseExam/blob/main/transaction.sql
transaction.sql	https://github.com/ZeroAC/databaseExam/blob/main/transaction.sql
蛇形矩阵.md	https://github.com/ZeroAC/databaseExam/blob/main/%E8%9B%87%E5%BD%A2%E7%9F%A9%E9%98%B5.md
蛇形矩阵.md	https://github.com/ZeroAC/databaseExam/blob/main/%E8%9B%87%E5%BD%A2%E7%9F%A9%E9%98%B5.md
README	https://github.com/ZeroAC/databaseExam
	https://github.com/ZeroAC/databaseExam#实验3-创建表及维护表
	https://github.com/ZeroAC/databaseExam#31-创表
	https://github.com/ZeroAC/databaseExam#sql语句
	https://github.com/ZeroAC/databaseExam#运行后的er图如下
	https://camo.githubusercontent.com/96d583a54d88a244a06ce8ff2d8fefca16d65b8d83d6031b876c0cd25c4e35a0/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531303136333731313838362e706e67
	https://github.com/ZeroAC/databaseExam#32-加列
	https://github.com/ZeroAC/databaseExam#sql语句-1
	https://github.com/ZeroAC/databaseExam#查表结构
	https://camo.githubusercontent.com/e12da1d30c88670d4ee0e1419319094540fcc6ea17953e653a5d7c93d01ed43d/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531303137313431393534372e706e67
	https://github.com/ZeroAC/databaseExam#33-改列
	https://github.com/ZeroAC/databaseExam#sql语句-2
	https://github.com/ZeroAC/databaseExam#34-删列
	https://github.com/ZeroAC/databaseExam#sql语句-3
	https://camo.githubusercontent.com/aaa5b217450d66ecdea8aae9cddaa9f15e953c7cf3f83a1bf96471a4f99b9126/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531303231343530353234322e706e67
	https://github.com/ZeroAC/databaseExam#35-插入数据
	https://github.com/ZeroAC/databaseExam#sql语句-4
	https://github.com/ZeroAC/databaseExam#36复制表
	https://github.com/ZeroAC/databaseExam#sql语句-5
	https://github.com/ZeroAC/databaseExam#37-删除表
	https://github.com/ZeroAC/databaseExam#sql语句-6
	https://github.com/ZeroAC/databaseExam#实验4-表及数据操作
	https://github.com/ZeroAC/databaseExam#41-更改表数据
	https://github.com/ZeroAC/databaseExam#sql语句-7
	https://github.com/ZeroAC/databaseExam#411-把学生周武的年龄改为-19系别改为信息
	https://github.com/ZeroAC/databaseExam#412-将教师王平的职称改为副教授
	https://github.com/ZeroAC/databaseExam#413-除表中数据-delect-from-表-where-条件
	https://github.com/ZeroAC/databaseExam#42-添加表数据
	https://github.com/ZeroAC/databaseExam#43-数据增删改练习1
	https://github.com/ZeroAC/databaseExam#431-向表-t中插入一个教师元组t6李红-女-30-副教授13002000-英语
	https://github.com/ZeroAC/databaseExam#432-将英语课程的任课教师号修改为t6
	https://github.com/ZeroAC/databaseExam#433-增加年龄字段-age并计算并填充所有学生的-age字段
	https://github.com/ZeroAC/databaseExam#434-再将所有学生的年龄增加-1岁
	https://github.com/ZeroAC/databaseExam#435-将高等数学课程不及格的成绩修改为-0分
	https://github.com/ZeroAC/databaseExam#436-将低于总平均分成绩的女同学成绩提高5--未完成
	https://github.com/ZeroAC/databaseExam#437-将张小明同学的信息分别从基本表-sc和-s中删除
	https://github.com/ZeroAC/databaseExam#438-从基本表-c中删除张雪老师的任课信息
	https://github.com/ZeroAC/databaseExam#44-数据增删改练习2
	https://github.com/ZeroAC/databaseExam#441-为-tc表添加term字段表示此授课是针对哪一级学生的第几学期开课的如2018级第-5学期开课则填写-20185
	https://github.com/ZeroAC/databaseExam#442-将-term字段统一填写-20181表示-2018级第-1期
	https://github.com/ZeroAC/databaseExam#443--修改学生选课表-sc添加-tnotermgrade字段
	https://github.com/ZeroAC/databaseExam#444-将-term字段统一填写-20181表示-2018级第-1期
	https://github.com/ZeroAC/databaseExam#445-按-score填充-grade10090为-a80以上为-b70分以上为-c60分以上为-d60分以下为-e
	https://github.com/ZeroAC/databaseExam#step-1-创建存储函数根据分数返回等级
	https://github.com/ZeroAC/databaseExam#step-2-调用存储函数-填充grade
	https://github.com/ZeroAC/databaseExam#实验5-简单查询
	https://github.com/ZeroAC/databaseExam#51-查询计算机系的所有教师
	https://camo.githubusercontent.com/4a5eb2f1b0184d6c9b859dcc8844ec0b8251f9a29a9910f9b72f301c837296f7/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313038353435303538372e706e67
	https://github.com/ZeroAC/databaseExam#52-查询所有女同学的姓名年龄
	https://camo.githubusercontent.com/3bec80e7bf39cea88d869f4b7f5380253bbce4ccc22c4ce2c129f4911cc70348/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313038353631333236332e706e67
	https://github.com/ZeroAC/databaseExam#53-查询计算机系教师开设的所有课程的课程号和课程名
	https://camo.githubusercontent.com/2ed3c914715f93695eae03651243f5dd3aeda738fe5da4c122d943d59009e339/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313038353833373632372e706e67
	https://github.com/ZeroAC/databaseExam#54-查询年龄在-1820岁之间的所有学生的信息
	https://camo.githubusercontent.com/bbc57beec06a473a8eb25eed9049d9073426f6682cf3c9fa3b80c088d2140cf6/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039303032363030332e706e67
	https://github.com/ZeroAC/databaseExam#55-查询年龄小于-20岁的所有男同学的学号和姓名
	https://camo.githubusercontent.com/f2e4eb281f7c5f238ded7c63e41568c1c26781b7e72b43225f5106ef6c676d3b/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039303231333033392e706e67
	https://github.com/ZeroAC/databaseExam#56-查询姓李的所有学生的姓名年龄和性别
	https://camo.githubusercontent.com/682837af68369f6361e209ee66c5a9d534e77ed225bad003a69f4372be300e77/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039303331363530362e706e67
	https://github.com/ZeroAC/databaseExam#57-查询所有女同学所选课程的课程号
	https://camo.githubusercontent.com/55a5e7f981f4942b60dd0f507d3fc4a2c6963afb8b1cf17cbcc21efb6747f4c3/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039303431333034332e706e67
	https://github.com/ZeroAC/databaseExam#58-查询至少有一门成绩高于-90分的学生姓名和年龄
	https://camo.githubusercontent.com/264905a5f7ef15404d75f9779b7d1d74fe44f4764d4edb576932ecb1b2968082/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039303530363736342e706e67
	https://github.com/ZeroAC/databaseExam#59-查询选修微机原理的所有学生的姓名和成绩
	https://camo.githubusercontent.com/802e0f813b6e1c464c577352efda0a7294aecbb5c8b53e6250ee3650482e2a38/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039303630313435302e706e67
	https://github.com/ZeroAC/databaseExam#510-试算所有数据库成绩统一增加-10后超过-100分按-100计算全班平均分是多少
	https://camo.githubusercontent.com/d965a98248430956a9ecbb82aed52181dcc7cb22221d88d09b2c988f47643208/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039303733343936392e706e67
	https://github.com/ZeroAC/databaseExam#511-试算所有数据结构成绩-60分以下的统一增加-10分后仍有多少人不及格
	https://camo.githubusercontent.com/af35481e6d442c1fcb2876cf5a80c5ca7b9a1df58ad570beaf170909c4e405c9/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039303834303133392e706e67
	https://github.com/ZeroAC/databaseExam#实验六-多表查询
	https://github.com/ZeroAC/databaseExam#61-查询至少选修课程号为21和41两门课程的学生的学号
	https://camo.githubusercontent.com/35d14cc5ec2bd9cf0c3d18bcf67e8f54d65f501a51b52013603cd46fe7477e9f/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039313435323633352e706e67
	https://github.com/ZeroAC/databaseExam#62-查询选修了高等数学或普通物理的学生姓名
	https://camo.githubusercontent.com/2c9dca3276848a1520a41ba683c9276a1a42ce3660dc7ea4fbaef1458b3d3246/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039313830333631362e706e67
	https://github.com/ZeroAC/databaseExam#63-查询选修了王平老师所讲授所有课程的学生的学号和成绩
	https://camo.githubusercontent.com/ed9c2c2282d279787b25f69a8f452c36f7c23f6fcedfb300478449b9b260b17a/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039313932313930322e706e67
	https://github.com/ZeroAC/databaseExam#64-查询未选修王老师所讲授任意课程的学生的学号和成绩
	https://camo.githubusercontent.com/d536fb78b233328401d14c943d23308bbfc7fe7e8de3b3b401d36394951db4b8/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039323032373837352e706e67
	https://github.com/ZeroAC/databaseExam#65-查询选修了计算机系教师所讲授的课程的学生姓名和成绩
	https://camo.githubusercontent.com/0c6d515201b1d900d8934dfb3fa7715a73b5f34eaff492aad4823966521f842f/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039323133343737372e706e67
	https://github.com/ZeroAC/databaseExam#66-查询学号比张小明同学大而年龄比他小的学生姓名
	https://camo.githubusercontent.com/0c6d515201b1d900d8934dfb3fa7715a73b5f34eaff492aad4823966521f842f/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039323133343737372e706e67
	https://github.com/ZeroAC/databaseExam#67-查询年龄大于所有女同学年龄的男学生的姓名和年龄
	https://camo.githubusercontent.com/cffb86e8b373ba680bc1daaf1d345994c2f06ef92fb28a863205eacdfefc8adb/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039323430393639382e706e67
	https://github.com/ZeroAC/databaseExam#68-查询未选修高等数学的学生的学号和姓名
	https://camo.githubusercontent.com/7e27a7893d24fc7e6341c72216fd797fabc8c77b65b7ab0d0aba792280189bcc/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039323530383831302e706e67
	https://github.com/ZeroAC/databaseExam#69-查询不是计算机系教师所讲授的课程的课程名和课程号
	https://camo.githubusercontent.com/7e27a7893d24fc7e6341c72216fd797fabc8c77b65b7ab0d0aba792280189bcc/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039323530383831302e706e67
	https://github.com/ZeroAC/databaseExam#610-查询未选修21号课程的学生的学号和姓名
	https://camo.githubusercontent.com/5124b453e4157986f2b9762b7873ea08e4ebcfd5d99416141e9aad5648ae41de/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039333030393734352e706e67
	https://github.com/ZeroAC/databaseExam#611-从学生表和教师表可以了解到哪些院系名称
	https://camo.githubusercontent.com/55cd3134877eb3ba02f6a0df78f4b2db6d7e9a6c983ae7433e86b01a7cd54366/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039333035363839342e706e67
	https://github.com/ZeroAC/databaseExam#612-查询哪些学生所选的课程是由本院系的教师教的列举学生姓名课程名和教师名
	https://camo.githubusercontent.com/5d558db15f977c8a7fec3a97b99c1d51368f99d4ee30b60417822eb2e1e529f0/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039333430353130322e706e67
	https://camo.githubusercontent.com/124e10e2ef7611839ba3628b0d2a6e186aa9520fc4acc458c3e0b9590cdd1924/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039333530333637372e706e67
	https://github.com/ZeroAC/databaseExam#613-如果在同一个班上课就认定为同学请列举所有可能的同学关系至少包含三列学生姓名同学姓名共同课程名
	https://camo.githubusercontent.com/19868f66fdd3bb050c074166993076067895c4ec2a5d3762fd2322e7e7e644f3/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039333830313233312e706e67
	https://camo.githubusercontent.com/6aed2b1db5110a58545bcff25cba7c2a5b2a982a124dce2f02644fe93e678575/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039343030373133392e706e67
	https://camo.githubusercontent.com/ba22314afbd92562ed75f8755ffc5e5187c44789155ae7989b34df73e64ce19f/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039343132383635372e706e67
	https://camo.githubusercontent.com/8d763c164d6fe1160220f5055df24d83eb6285a57a98f688a3d5ed254906e8b0/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039343333373636372e706e67
	https://github.com/ZeroAC/databaseExam#614-由于课程有上下承接关系请列举课程先后关系必须先上的在前后上的在后无承接关系的不列举
	https://camo.githubusercontent.com/8bbc26349ca34ad9422dd138574f68d391fa0ba432fb3486e2db4675c6fe115f/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039343531323238302e706e67
	https://github.com/ZeroAC/databaseExam#实验七-统计查询
	https://github.com/ZeroAC/databaseExam#71-查询女同学的人数
	https://camo.githubusercontent.com/f539f75194a76ab96f83826aa79cc332020540fee8e5ac93e2c1f068816a2135/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039353035363631322e706e67
	https://github.com/ZeroAC/databaseExam#72-查询男同学的平均年龄
	https://camo.githubusercontent.com/9c8037852340ad254d2154a7f1fcfc31e88045bfa85b19c67aed9da5d974fdd7/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039353132343032362e706e67
	https://github.com/ZeroAC/databaseExam#73-查询男女同学各有多少人
	https://camo.githubusercontent.com/83d836b3fe832988fbd936d7d0a1dff355dfb0c8436e84e401c461a67c90fe7d/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039353135333331302e706e67
	https://github.com/ZeroAC/databaseExam#74-查询年龄大于女同学平均年龄的男学生的姓名和年龄
	https://camo.githubusercontent.com/138558aecf2289c111d30e4e47b3118710a1769a1d5d2b22f4d520113951e67d/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039353334313937322e706e67
	https://github.com/ZeroAC/databaseExam#75-查询所有学生选修的课程门数
	https://camo.githubusercontent.com/e1f5809333365941c7797f23916799c2d4b6e810262af7bc1501bbb2bf29e766/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039353432373837342e706e67
	https://github.com/ZeroAC/databaseExam#76-查询每门课程的学生选修人数只输出超过2人10人的数据不好造的课程要求输出课程号和课程名及选修人数查询结果按人数降序排列若人数相同按课程号升序排列
	https://camo.githubusercontent.com/cfbc2ebbcd3ada0a0c45a78205cde6cff652290aee4febc16ce02223301c4c74/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039353532363030332e706e67
	https://github.com/ZeroAC/databaseExam#77-查询只选修了一门课程的学生学号和姓名
	https://camo.githubusercontent.com/bf07d9078c3360e70b80a175a7bf6a599cbf9fe1a7bb428d1f0266cfb47d413b/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039353630353533352e706e67
	https://github.com/ZeroAC/databaseExam#78-查询至少选修了两门课程的学生学号
	https://camo.githubusercontent.com/b138cacdfb2d08db11f451f07c32a2a54dd21051e5250cc6ca78eb77d750ea94/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039353634393839312e706e67
	https://github.com/ZeroAC/databaseExam#79-查询至少讲授两门课程的教师姓名和其所在系
	https://camo.githubusercontent.com/1014cc4108e410ff769023b1439a75f629af53b3d48ef6101873126fc2283b80/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039353733353632332e706e67
	https://github.com/ZeroAC/databaseExam#710-查询高等数学课程的平均分
	https://camo.githubusercontent.com/0570a6b1f3e84cce15944730e8e2d341860164dd21c4b19d887820531e9dcb9c/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039353830343233342e706e67
	https://github.com/ZeroAC/databaseExam#711-查询每个学生的总分要求输出学号和分数并按分数由高到低排列分数相同时按学号升序排列
	https://camo.githubusercontent.com/0a41eddf1c226dce49e2d29911da4cee8787b86b3a4fd8641c53b0381fe6a377/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039353833383333332e706e67
	https://github.com/ZeroAC/databaseExam#712-查询各科成绩等级分布情况即看每门课程-a等多少人b等多少人
	https://camo.githubusercontent.com/3e49ad53c27215f2a6483405ebfda4beca7768f8f62aa57c91619a410a3690d5/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039353932313933332e706e67
	https://github.com/ZeroAC/databaseExam#713--统计各科成绩等级分布情况存入新表-statgrade即看每门课程-a等多少人b等多少人
	https://camo.githubusercontent.com/3e49ad53c27215f2a6483405ebfda4beca7768f8f62aa57c91619a410a3690d5/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313039353932313933332e706e67
	https://github.com/ZeroAC/databaseExam#714--统计各科课程号课程名选课人数平均分最高分最低分并存入新表-statscore
	https://camo.githubusercontent.com/0821be1330c971768dc1a66f34dcff4e7d623e4ad95bbce0ecd67cbde3694f0a/68747470733a2f2f7069632d313235363837393936392e636f732e61702d6e616e6a696e672e6d7971636c6f75642e636f6d2f696d6167652d32303231303531313130303130383839362e706e67
Readme	https://github.com/ZeroAC/databaseExam#readme-ov-file
Activity	https://github.com/ZeroAC/databaseExam/activity
1 star	https://github.com/ZeroAC/databaseExam/stargazers
1 watching	https://github.com/ZeroAC/databaseExam/watchers
0 forks	https://github.com/ZeroAC/databaseExam/forks
Report repository	https://github.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2FZeroAC%2FdatabaseExam&report=ZeroAC+%28user%29
	https://github.com
Terms	https://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacy	https://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Security	https://github.com/security
Status	https://www.githubstatus.com/
Community	https://github.community/
Docs	https://docs.github.com/
Contact	https://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.