Zoho analytics wrong query?

Hello again,

I have created a dashboard and I want to have a table to display all projects that were lost before the project entered the "Offer" stage. I created a custom query table, but after running the code it still displays projects that were transitioned to "Close Lost".

Here is the code, if you have any idea why is it wrong please let me know as I struggled with this for a few days now:

SELECT DISTINCT

"Stage History"."Stage",

"Deals"."Amount" AS 'Lost AMOUNT Region',

"Deals"."Deal Owner Name",

"Deals"."Id",

"Deals"."Link to CRM"

FROM "Deals",

"Stage History"

WHERE "Stage History"."Deal Name" = "Deals"."Id"

AND "Stage History"."Stage" NOT LIKE '%Offer%'

AND ("Deals"."Stage" LIKE '%Closed Lost%')