Write a SQl Wedding Query

Write a SQl Wedding Query

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

SELECT Bride 

FROM india_ Brides
WHERE FatherInLaw = ‘Millionaire’ 

AND Count(Car) > 10 

AND HouseStatus = ‘ThreeStoreyed’
AND BrideEduStatus 

IN (BCA ,BE ,Degree ,MCA ,MBA) 

AND Having Brothers = Null 

AND Sisters = Null

SELECT Gold, Cash, Car, BankBalance

FROM FatherInLaw 

UPDATE MyBankAccout 

SET MyBal = MyBal + FatherInLawBal 

UPDATE MyLocker 

SET MyLockerContents = MyLockerContents + FatherInLawGold 

INSERT INTO MyCarShed 

VALUES (‘BMW’) 

END GO

Then the Bride writes the below query:

DROP HUSBAND;
Commit;