WHERE 조건
select empno, ename
from emp
where job LIKE '%SALESMAN'
order by sal desc, empno
장씨성을 가진 선수
select p.player_name, p.position, p.join_yyyy, p.back_no
from player p where p.player_name like '장%'
기본 JOIN
select empno, ename, sal, dname
from emp join dept
on dept.deptno=emp.deptno
where loc='DALLAS';
= 같은 버전 natural join
select empno, ename, sal, dname
from emp natural join dept
where loc='DALLAS';
축구팀별 경기장
select region_name, team_name, orig_yyyy, seat_count
from team t join stadium st on t.team_id=st.hometeam_id
평균
select round(avg(height),1), avg(weight)
from player
Insert / delete
insert into dept
values ('59','Progs','LA');
delete from dept where deptno=59
insert into player
values ('2021999','이름','K07','kingseul','sponge',
'1955','MF','99','Korea','55/05/02','1','199','99')
between
select player_name, position, weight, height, (height-weight) 계산무게
from player
where weight BETWEEN 75 and 80 and height BETWEEN 170 and 180;
