PostgreSQL scratch queries

-- update from a select query
update "subscriptionDetails"  set  status ='active'
from  (
   select t."id" from tenants  t where t."senderEmail" in ('imprezzdev+ravinder@gmail.com' )
 ) as "t" where  "t"."id" = "tenantId"