(class 3)
PostgreSQL
Object Relational DataBase Management System

クラス(3)
クラスの更新
UPDATE weather
 SET temp_hi = temp_hi - 2, temp_lo = temp_lo - 2
 WHERE date > '11/28/1994;
クラスの削除
DELETE FROM weather WHERE city = 'Hayward';
集計関数
SELECT city, max(temp_lo) FROM weather GROUP BY city;