Write a query to display the name and transaction id of the employees whose transaction amount was
Question:
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.
Â
Expert Answer:
Task 1 sql SELECT name transactionid FROM employees WHERE transactionamount 100000 This code retrieves data from the employees table It selects the name and transactionid columns for employees who hav... View the full answer
