｢体験レベル｣を終えたあなたの為のSQL入門 次の一歩 のサンプルクエリ

before_having.sql

select code, max(price) from grpsample group by code;

before_subquery.sql

select cust_id from sales where amount>1000;

group_by.sql

select code, count(*) , sum(price) from grpsample group by code;

group_by_2.sql

select code, min(price), max(price), avg(price) from grpsample group by code;

having.sql

select code, max(price) from grpsample group by code
having max(price) >= 500;

join.sql

select * from pref
join area on (pref.area_id = area.id);

left_outer_join.sql

select * from pref
left outer join area on (pref.area_id = area.id);

no_join.sql

select * from pref, area
  where pref.area_id = area.id;

subquery.sql

select * from cust where id IN (
  select cust_id from sales where amount>1000
);