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?
This clearly sounds like homework. So I can guide you but I can't just give you a canned answer.
Why do you think you need a MOD operation for this query? Is that just a random requirement to add to the query to show you can use it or do you need one for some actual purpose?