Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1.select customer_name,account_number,loan_number from account natural join customer natural join depositor natural join loan natural join borrower;
- 2.select customer_name from loan natural join borrower where amount>1000;
- 3.select customer_name,customer_street,customer_city from customer natural join loan natural join borrower where branch_name='North Town';
- 4.select distinct customer_name,amount from loan natural join borrower where customer_city='Rye';
- 5. select customer_name,loan_number from customer natural join borrower natural join loan where branch_name='Perryridge';
- 6. select customer_name,account_number from customer natural join depositor;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement