sqlite3によるSQL入門

平均点が８０点以上

d:\sql>sqlite3 test.db
SQLite version 3.7.9 2011-11-01 00:52:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table person(name text, score integer);
sqlite> insert into person values('reika', 97);
sqlite> insert into person values('reika', 87);
sqlite> insert into person values('tae', 32);
sqlite> insert into person values('tae', 56);
sqlite> insert into person values('moe', 97);
sqlite> insert into person values('moe', 73);
sqlite> insert into person values('aya', 83);
sqlite> insert into person values('aya', 78);
sqlite> select name, avg(score) from person group by name;
aya|80.5
moe|85.0
reika|92.0
tae|44.0
sqlite> select name, avg(score) from person group by name having avg(score) >= 80;
aya|80.5
moe|85.0
reika|92.0