Questão 1473890

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 (c) permite selecionar todos os customers que tem ao menos duas contas na branch ‘Perryridge’.’.