Question

1. Write SQL Commands for the following on the basis of Given table Transaction.

To display all ANO, ANAME and DOT of those persons whose Date of transaction is after 2019-12-
30.
Increase the Amount of Rishabh Jain by 3000.
To display details of all transactions of TYPE Saving
Display a report showing Account no, account name, amount and Interest (5% of amount) for saving
account holders.​

Answer 1

Explanation:

. Write SQL Commands for the following on the basis of Given table Transaction.

To display all ANO, ANAME and DOT of those persons whose Date of transaction is after 2019-12-

30.

Increase the Amount of Rishabh Jain by 3000.

To display details of all transactions of TYPE Saving

Display a report showing Account no, account name, amount and Interest (5% of amount) for saving

account holders. your questions is me not answer to me