Seu próximo nível começa aqui
Seu desenvolvimento não pode ter limites. Garanta sua Assinatura Ilimitada e libere uma preparação completa com os melhores professores do Brasil.
O conjunto (b) permite selecionar todos os customers que...
figura I
select customer-name, borrower.loan-number as loan-id, amount from borrower, loan where borrower.loan-number = loan.loan-number
(a)
(select customer-name from depositor) intersect
(select customer-name from borrower)
(b)
select distinct T.customer-name
from depositor as T where not unique ( select R.customer-name
from account, depositor as R where T.customer-name = R.customer-name and R.account-number = account.account-number and account.branch-name = ‘Perryridge’)
(c)
select distinct T.branch-name from branch as T, branch as S
where T.assets > S.assets and S.branch-city = ‘Brooklyn’
(d)
select branch-name from branch where assets > some
(select assets from branch where branch-city = ‘Brooklyn’)
(e)
select T.customer-name from depositor as T where unique ( select R.customer-name from account, depositor as R where T.customer-name = R.customer-name and R.account-number = account.account-number and account.branch-name = ‘Perryridge’)
(f)
Com base no esquama de dados mostrado na figura e no conjunto de instruções SQL mostradas de (a) a (e), julgue os itens a seguir.
O conjunto (b) permite selecionar todos os customers que tem um loan e um account.