Comments by Harini Swathi (Top 1 by date)

Consider the following relational schema for a Loan database application:
Customer {Customer_id, Customer_name, Age, phone_no}
1)Loan { Loan_id, Amount, Customer_id)}
Include the constraint on Loan_id that it starts with letter ‘L’.
2)Display the list of the customer_ids and total Loan amount taken.
3)Display the Customer_id and Customer_name who have taken less than two loans.