给出一个年份,判断该年是否为闰年
时间: 2024-05-24 22:12:48 浏览: 11
1)SELECT name, gender FROM students WHERE department='IS' OR department='MA' OR department='CS';
2)SELECT name, gender FROM students WHERE department<>'IS' AND department<>'MA' AND department<>'CS';
3)SELECT course_id, credits FROM courses WHERE course_name='DS Design';
4)SELECT * FROM students ORDER BY department, age DESC;
5)SELECT AVG(score) FROM scores WHERE course_id=1;
6)SELECT course_id, COUNT(*) FROM scores WHERE score>=90 GROUP BY course_id;
7)SELECT student_id FROM scores GROUP BY student_id HAVING COUNT(*)>=3;
8)SELECT student_id, COUNT(*) FROM scores WHERE score>=90 GROUP BY student_id HAVING COUNT(*)>=3;
9)SELECT students.name, courses.course_name FROM students INNER JOIN scores ON students.id=scores.student_id INNER JOIN courses ON scores.course_id=courses.course_id;
10)SELECT DISTINCT c2.course_name, c1.course_name FROM courses c1 INNER JOIN prerequisite p ON c1.course_id=p.course_id INNER JOIN courses c2 ON p.prereq_id=c2.course_id;
11)SELECT students.id, students.name, courses.course_name, scores.score FROM students INNER JOIN scores ON students.id=scores.student_id INNER JOIN courses ON scores.course_id=courses.course_id;
12)SELECT s2.name FROM students s1 INNER JOIN students s2 ON s1.department=s2.department WHERE s1.name='刘晨';
13)SELECT students.id, students.name FROM students INNER JOIN scores ON students.id=scores.student_id INNER JOIN courses ON scores.course_id=courses.course_id WHERE courses.course_name='信息系统';
14)SELECT name, age FROM students WHERE department<>'IS' AND age<(SELECT age FROM students WHERE name='某一学生' AND department='IS');
15)SELECT students.name FROM students INNER JOIN scores ON students.id=scores.student_id WHERE scores.course_id=1;
16)SELECT name FROM students WHERE id NOT IN (SELECT student_id FROM scores WHERE course_id=1);
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)