CREATE PROCEDURE
MyMarriage (BrideGroom Male (25) ,Bride Female(20) )
Sisters =Null
AS
BEGIN

SELECT Bride FROM india_ Brides WHERE FatherInLaw = ‘Millionaire’
AND Count(Car) > 20 AND HouseStatus =’ThreeStoreyed’
AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MiBA)
AND Having Brothers= Null
AND

SELECT Gold ,Cash,Car,BankBalance
FROM FatherInLaw

UPDATE MyBankAccout
SETMyBal = MyBal + FatherInLawBal

UPDATE
MyLocker
SET MyLockerContents = MyLockerContents + FatherInLawGold

INSERT INTO
MyCarShed VALUES(‘BMW’)

DROP HUSBAND;
Commit;