Given the Bank database that contains the following tables (primary keys are underlined and foreign keys are preceded with #):
Agency(agencyNumber, agencyName, city, assets)
Client
(clientNumber, firstName, lastName, clientCity)
Account(accountNumber, #agencyNumber, #clientNumber, balance)
Loan(loanNumber, #agencyNumber, #clientNumber, amount )
- Without using DISTINCT, write the SQL query equivalent to the following one
SELECT DISTINCT clientNumber
FROM Account
WHERE balance < 1000="" or="" balance=""> 100000 ;