select * from book where create_date >= '2007/12/05 10:00:00' AND create_date <= '2008/05/12 10:00:00';

select * from book where now() - interval '3 month' <= create_date;

SELECT kb_user.pt <-> hot_spring.pt as distance, hot_spring.name as spring, place.name as place FROM kb_user, hot_spring, place WHERE kb_user.name = 'shokai' and place.area ~ hot_spring.pt ORDER by distance asc;

SELECT country.cname, country.population, river.rname, river.len, mount.mname, mount.elevation FROM country, river, mount, mhold, rhold WHERE country.population > 50000 AND mount.elevation > 4000 AND river.len > 1000 AND country.cname = mh…

joinわかった！ select rhold.cname, rhold.rname,len from rhold,river where river.len > 700 AND river.rname = rhold.rname;

授業でもらったビルドを入れたらクライアントツールとか全部はいった。 universal build 8.3.1と書いてあったdmcに。