---
title: "sql基础"
author: "microjava"
date: "2009-10-27T21:36:30Z"
tags: []
slug: "sql"
draft: false
lastmod: "2009-10-27T21:36:30Z"
id: 505188
url: "https://microjava.iteye.com/blog/505188"
---

一个表student，三个字段，classicid,age,name,如何查出平均年龄大于20的班级？

select classicid from student group by classicid having avg(age) > 20;