ECNU数据库作业——Lab2

Lab 2

查询题 1

List the name, born state and age of the heads of departments ordered by age.

SELECT `name`, born_state, age
FROM head
ORDER BY age;

查询题 2

What are the maximum and minimum budget of the departments?

SELECT MAX