Leetcode HARD 2118 - Build The Equation CONCAT vs GROUP_CONCAT : Explained by Everyday Data Science

Question: leetcode.com/p...
SQL Schema:
Create table If Not Exists Terms (power int, factor int)
Truncate table Terms
insert into Terms (power, factor) values ('2', '1')
insert into Terms (power, factor) values ('1', '-4')
insert into Terms (power, factor) values ('0', '2')
Pandas Schema:
data = [[2, 1], [1, -4], [0, 2]]
terms = pd.DataFrame(data, columns=['power', 'factor']).astype({'power':'Int64', 'factor':'Int64'})
#leetcodesolutions #datascience #sql

[@Karthikmahi007]

with cte as (select power, case when factor>=0 then concat('+',factor) else factor end as factor from terms), cte2 as (select 1 as nill,power,factor, case when power=0 then factor when power =1 then concat(factor,'x') else concat(factor,'x^',power) end as eqn from cte order by power desc) select concat(group_concat(eqn order by power desc separator ''),'=0' ) as equation from cte2 group by nill;