Question

Q5. Wnte SQL queries (A) to (D), which
based on the following table Customer and Transact
Transack
Amount
Coo
Type
1000
Сро
C1
C2
Customer
Name
Raj
Tom
Krush
100
De
ū0518
500
DRE
400
To display details of all Transactions which are debited to a customer.
To display maximum amount of transaction for each Type from the table Transact
To display Name of each customer and his corresponding Amount of traction for all Debuts
To display the Total Amount Credited in the table Transact
D​

Answer 1

Explanation:

yes correct