hey

CREATE TABLE Customer (
Custid INT PRIMARY KEY,
Custname VARCHAR(255),
Age INT,
phno VARCHAR(15)
);

CREATE TABLE HLoan (
HLoanid INT PRIMARY KEY,
Amount DECIMAL(10, 2),
Custid INT,
FOREIGN KEY (Custid) REFERENCES Customer(Custid)
);

CREATE TABLE VLoan (
VLoanid INT PRIMARY KEY,
Amount DECIMAL(10, 2),
Custid INT,
FOREIGN KEY (Custid) REFERENCES Customer(Custid)
);

INSERT INTO Customer VALUES (1, 'John Doe', 30, '123-456-7890');
INSERT INTO Customer VALUES (2, 'Jane Smith', 25, '987-654-3210');

INSERT INTO HLoan VALUES (101, 50000.00, 1);
INSERT INTO HLoan VALUES (102, 75000.00, 2);

INSERT INTO VLoan VALUES (201, 30000.00, 1);
INSERT INTO VLoan VALUES (202, 45000.00, 2);

SELECT Custid, COUNT(*) AS NumOfVLoans
FROM VLoan
WHERE Custid = 1;

SELECT Custid, SUM(Amount) AS TotalHLoanAmount
FROM HLoan
GROUP BY Custid;

CREATE VIEW CustomersWithBothLoans AS
SELECT DISTINCT H.Custid
FROM HLoan H
JOIN VLoan V ON H.Custid = V.Custid;
SELECT*From CustomersWithBothLoans;