Question
Find all customers who do have a loan at the bank, but do not have an account at the bank.

Answers

select customer_name from loan natural join borrower
where customer_name not in
(select customer_name from account natural join depositor);   Your Comment






Search
Can you Answer!!
  • Q Give the classification of Balinese in animal kingdom?
  • Q What kind of data is important for specific business requirements and how, as a data scientist will you go about collecting that data?
  • Q What is Autopostback event in ASP.Net?
  • Q Differences between proxies and adapters?
  • Q What are the tools used in SAP-CRM
  • Q George Simenon created Maigret - what nationality was he
  • Q What are the different kinds of chlorophyll and where are these found?
  • Q When are static and non static variables of the class initialized?
  • Q The first chamber of commerce in Britain was founded in which city in 1783?
  • Q State the essential qualities of business opportunity.
  • Q Write the following rational numbers in its simplest form: -54/98 , 27/81