4장 연습문제
- 최초 등록일
- 2020.05.28
- 최종 저작일
- 2020.04
- 8페이지/ MS 워드
- 가격 1,500원
소개글
"4장 연습문제"에 대한 내용입니다.
목차
없음
본문내용
5-1.
select d.deposit_num, c.name, b.balance
from client c, deposit d
where c.ssn = d.ssn
5-2.
select phone, ssn
from client
where name='박지성'
5-3.
select balance
from deposit
where branch_name='성남지점'
5-4.
select branch_name, address
from branch
where branch_head = '고소영'
5-5.
select branch_head, address
from branch
where branch_name = '광주지점'
5-6.
select d.deposit_num, d.branch_name, d.balance
from client c, deposit d
where c.ssn=d.ssn and c.name='김광식'
5-7.
select c.name, c.address, d.balance
from client c, deposit d
where c.ssn = d.ssn and d.branch_name='성남지점'
5-8.
select c.name, d.balance
from client c, deposit d
where c.ssn=d.ssn and branch_name='성남지점' and c.name like '김%'
5-9
select c.name
from client c, deposit d
where c.ssn=d.ssn and d.balance>=100000
5-10
select distinct b.branch_name, b.branch_head
from deposit d, branch b
where d.branch_name=b.branch_name and balance >=100000
참고 자료
없음