Advertisement
HmHimu

sql

Oct 28th, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. 1.select customer_name,account_number,loan_number from account natural join customer natural join depositor natural join loan natural join borrower;
  2.  
  3.  
  4. 2.select customer_name from loan natural join borrower where amount>1000;
  5.  
  6.  
  7.  
  8. 3.select customer_name,customer_street,customer_city from customer natural join loan natural join borrower where branch_name='North Town';
  9.  
  10.  
  11.  
  12. 4.select distinct customer_name,amount from loan natural join borrower where customer_city='Rye';
  13.  
  14.  
  15. 5. select customer_name,loan_number from customer natural join borrower natural join loan where branch_name='Perryridge';
  16.  
  17. 6. select customer_name,account_number from customer natural join depositor;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement