sezemiadmin · March 26, 2019 10:51
diff --git a/before_having.sql b/before_having.sql
 select code, max(price) from grpsample group by code;
diff --git a/before_subquery.sql b/before_subquery.sql
 select cust_id from sales where amount>1000;
diff --git a/group_by.sql b/group_by.sql
 select code, count(*) , sum(price) from grpsample group by code;
diff --git a/group_by_2.sql b/group_by_2.sql
 select code, min(price), max(price), avg(price) from grpsample group by code;
diff --git a/having.sql b/having.sql
 select code, max(price) from grpsample group by code
 having max(price) >= 500;
diff --git a/join.sql b/join.sql
 select * from pref
 join area on (pref.area_id = area.id);
diff --git a/left_outer_join.sql b/left_outer_join.sql
 select * from pref
 left outer join area on (pref.area_id = area.id);
diff --git a/no_join.sql b/no_join.sql
 select * from pref, area
  where pref.area_id = area.id;
diff --git a/subquery.sql b/subquery.sql
 select * from cust where id IN (
  select cust_id from sales where amount>1000
 );
	select code, max(price) from grpsample group by code
	having max(price) >= 500;
	select * from pref
	left outer join area on (pref.area_id = area.id);
	select * from cust where id IN (
	select cust_id from sales where amount>1000
	);