Query unused forms datastores processes

Show forms with 0 tickets in teh last 24 months (see fixed date in query !!)

SELECT * FROM [Form] WHERE [Id] NOT IN ( SELECT [FormField].[Form_Id]

 FROM [FormInstanceValue], [FormField], [FormInstance]
 WHERE [FormInstanceValue].[Field_Id] = [FormField].[Id]
 AND [FormInstanceValue].[FormInstance_Id] = FormInstance.Id
 AND [FormInstance].[LastUpdate] > '2020-12-12'

)

Query to show processes without tickets in the last 24 months (see fixed date in query !!)

SELECT * FROM [Process] WHERE [Id] NOT IN ( SELECT [ProcessInstanceStep].[OriginalProcessId]

 FROM [ProcessInstanceStep], [ProcessInstance]
 WHERE [ProcessInstanceStep].[ProcessInstanceId] =  [ProcessInstance].[Id]
 AND [ProcessInstance].DateStarted > '2020-12-12'

)

Unused datastore parameters in selection fields (except the retired forms):

SELECT * FROM [Parameter] WHERE [Name] NOT IN (SELECT COALESCE([SelectionParameter], ) FROM [FormField], [Form] WHERE [FormField].[Form_Id] = [Form].Id AND [Form].IsRetired = 0)