Funnel Conversion in SQL, and the Step That Shows 100%

Conditional aggregation gives a funnel in one row. Then the checks: count sessions not events, and find out why one step converts at 100% while overall conversion is 30% or 20%.