Write a query to display the name and transaction id of the employees whose transaction amount was greater than 100000

Task 2
Write a query to display all the customer names with their saving accounts number having balance more than 10000and less than 50000.

Task 3
Write a query to display all the saving account number with their owner's name.

Task 4
Write a query to display the transaction details and customer name whose transaction are greater than 1500000 in their saving account .

Task 5
Display the name of the employees whose bank name start with 'M'.

Task 6
Write a query to display loan account number of all the customers whose name starts with 'I' and end with 'n'.

Task 7
Write a query to display employee name and transactions amount of all the employees. If an employee has not done any transaction then his transaction amount should be NULL.

Task 8
Write a query to display customer name and account number of those customers who made transactions in year 2003.
Task 9
Write a query to display each employees bank branch details.

Task 10
Write a query to display all the names of employees with total amount of transaction till now.

 

savingaccounts Account number VARCHAR (20) branch_id VARCHAR(15) customer_id VARCHAR(15) current balance INT(11) Indexes 1 transaction transaction_id VARCHAR(10) transaction_amount INT (11) transaction_date DATE loanAccount_num ber VARCHAR(20) savingAccount_number VARCHAR(20) transaction Details VARCHAR (50) eid VARCHAR(10) Indexes customer customer_id VARCHAR(15) name VARCHAR(20) Address VARCHAR(100) phoneNum VARCHAR(15) Indexes I OC loanaccounts Account number VARCHAR(20) branch_id VARCHAR(15) max_credit INT (11) customer_id VARCHAR(15) current_credit INT(11) Indexes employee eid VARCHAR(10) branch_id VARCHAR(15) name VARCHAR(25) address VARCHAR(50) designation VARCHAR(25) age INT(11) Indexes Ot branch branch_id VARCHAR(15) O bank_id INT(11) branch_address VARCHAR(60) Indexes bank bank_id INT(11) bank_name VARCHAR(30) Head Office Address VARCHAR(100) startDate DATE Indexes