SQL 基础查询

查询是数据库最常见的操作。

一、基本查询

SELECT name, age FROM users
WHERE age >= 18
ORDER BY age DESC;

二、聚合

SELECT COUNT(*) AS total, AVG(age) AS avg_age
FROM users;