What's the difference between a Flow and a Workflow Rule?
Use the provided automation metadata, step, and execution records to compare the two automation types. Write a SQL query that summarizes their definitions, activity, steps, and execution outcomes.
Output
- One row per automation type, with columns
automation_type, definition_count, active_definition_count, avg_steps_per_definition, execution_count, and successful_execution_count.
- Include only Flow and Workflow Rule records, ordered with Flow first and Workflow Rule second.
Output details
- Round
avg_steps_per_definition to two decimal places.
- Treat definitions with no step records as having zero steps for the average.
- Report
execution_count and successful_execution_count as 0 when no executions exist.
- Count an execution as successful only when its status is
completed.
- Count every definition, step, and execution record without deduplication.
- Count a definition as active only when
is_active is true.
