Query 1 – Active Homeowner Policies where the Roof is Over 17 Years Old.
My answer was : ELECT P.status, P.policyType, P.insuredID AS "POLICY INSURED ID", H.roofYearBuilt, H.policyID,H.homeownerID,
P.policyID AS "POLICY ID", InsuredLog.insuredID
FROM HomeownerDwelling H INNER JOIN Policy P
ON H.policyID = P.policyID CROSS JOIN InsuredLog
WHERE roofYearBuilt <= 1998 and policyType=4 and status=1;
**I WAND TO USE MOD OPERATION IN "WHERE CLAUSE" OR ANY OTHER CONDITION. HOW CAN I DO IT?