Skip to content

Instantly share code, notes, and snippets.

@ehzawad

ehzawad/SQL.sql

Created February 3, 2016 07:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ehzawad/792fc461ab8945ab52c5 to your computer and use it in GitHub Desktop.
Save ehzawad/792fc461ab8945ab52c5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SQL.sql
1. select Customer_street from customer where Customer_name in(select Customer_name from borrower where Loan_number in(select loan_number from loan));
2. select amount from loan where amount >(select amount from loan where Loan_number = 'L-15');
3. SELECT CUSTOMER_NAME,CUSTOMER_CITY FROM CUSTOMER WHERE CUSTOMER_NAME IN (SELECT CUSTOMER_NAME FROM BORROWER WHERE LOAN_NUMBER IN(SELECT LOAN_NUMBER FROM LOAN WHERE BRANCH_NAME='Downtown'));
4.SELECT CUSTOMER_NAME,CUSTOMER_CITY FROM CUSTOMER WHERE CUSTOMER_NAME IN (SELECT CUSTOMER_NAME FROM BORROWER);
5. SELECT CUSTOMER_NAME FROM BORROWER WHERE LOAN_NUMBER IN(SELECT LOAN_NUMBER FROM LOAN WHERE BRANCH_NAME IN(SELECT BRANCH_NAME FROM LOAN WHERE LOAN_NUMBER IN (SELECT LOAN_NUMBER FROM BORROWER WHERE CUSTOMER_NAME= 'Adams')));
6: SELECT CUSTOMER_NAME FROM CUSTOMER WHERE CUSTOMER_NAME IN (SELECT CUSTOMER_NAME FROM BORROWER WHERE LOAN_NUMBER IN(SELECT LOAN_NUMBER FROM LOAN WHERE BRANCH_NAME='Perryridge'));
7: SELECT CUSTOMER_NAME FROM CUSTOMER WHERE CUSTOMER_NAME IN (SELECT CUSTOMER_NAME FROM BORROWER WHERE LOAN_NUMBER IN (SELECT LOAN_NUMBER FROM LOAN WHERE AMOUNT IN (SELECT MAX(AMOUNT) FROM LOAN ) )) ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment