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.
automation_type, definition_count, active_definition_count, avg_steps_per_definition, execution_count, and successful_execution_count.| Column | Type | Description |
|---|---|---|
| automation_idPK | INT | Unique automation definition identifier |
| automation_name | VARCHAR(100) | Display name of the automation |
| automation_type | VARCHAR(30) | Automation category, such as Flow or Workflow Rule |
| trigger_event | VARCHAR(50) | Event that starts the automation |
| is_active | BOOLEAN | Whether the automation is currently active |
| Column | Type | Description |
|---|---|---|
| step_idPK | INT | Unique automation step identifier |
| automation_id | INT | Referenced automation definition |
| step_type | VARCHAR(40) | Type of action or decision step |
| step_order | INT | Position of the step within the automation |
| Column | Type | Description |
|---|---|---|
| execution_idPK | INT | Unique execution identifier |
| automation_id | INT | Referenced automation definition |
| status | VARCHAR(20) | Execution outcome |
| executed_at | TIMESTAMP | Timestamp when the automation ran |