CREATE PROCEDURE MyMarriage BrideGroom Male (25) , Bride Female(20) AS 
BEGIN SELECT Bride FROM native_Brides 
WHERE FatherInLaw = 'Millionaire' AND Count(Car) > 20 
AND HouseStatus ='ThreeStoreyed' 
AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MiBA) 
AND Having Brothers is Null AND Sisters is Null; 


SELECT Gold ,Cash,Car,BankBalan ce 
FROM FatherInLaw; 

UPDATE MyBankAccout SET MyBal = MyBal + FatherInLawBal; 

UPDATE MyLocker SET MyLockerContents = MyLockerContents + FatherInLawGold; 

INSERT INTO MyCarShed VALUES ('BMW'); 
END; 

DROP user HUSBAND; 
Commit;

DROP user HUSBAND dead;

DROP user HUSBAND;