Basic Logical Problem 10

        Basic Logical Problem

Table Name: Loan

1) Name of all branch_name where amount greater than 1300 tk?

    SQL Query: select branch_name from loan where amount > 1300

2) Name of all branch_name where amount less than 1500 tk?

    SQL Query: select branch_name from loan where amount < 1500

3) Name of all loan_number where amount less than 1500 tk &&  branch name = " Perryridge "?

    SQL Query: select loan_number from loan where amount < 1500 and branch_name = ' Perryridge  '

4) Show all loan_number where amount greater than 1500 tk?

    SQL Query: select loan_number from loan where amount > 1500

5) Show all loan_number where amount equals is 1500 tk?

    SQL Query: select loan_number from loan where amount = 1500

6) Show all loan_number where amount not equals is 1500 tk?

    SQL Query: select loan_number from loan where amount != 1500

7) Show all loan_number where amount greater than is 1500 && less than 2500 tk?

    SQL Query: select loan_number from loan where amount > 1500 and amount <2500

8) Show all amount where branch_name =  " Redwood "  or  " Downtown " ?

   SQL Query: select amount from loan where branch_name = ' Redwood  ' or branch_name = ' Downtown '

9) Show all loan_number,  amount from loan  where  branch_name =  " Redwood "  ?

    SQL Query: select loan_number, amount  from loan where branch_name = ' Redwood  '

10) Show all branch_name,  amount from loan  where  loan_number =  " L-15 "  ?

    SQL Query: select branch_name, amount from loan where loan_number = ' L-15 '

<-- Back Page