mysql - Dynamically creating columns from row data using Select in Bigquery

Question

Background

I want to rename my case statement in sql select statement dynamically.

Eg:

SELECT (case when id= x.id then x.sums end) x.id as (select id,count(*) sums from table group by id) x

what i want the output is list of columns created ,with Labels as distinct id's from "id" column.

However,this variable x.id is not dynamically outputing values,rather i get output a single column x.id.

Eg:

Columns in table...

id---c1----c2

---

1----x1---x2

2----x2----x3

3----x4----x5

columns expected after running query...

1-----2----3

---

but actual o/p column is::

x.id

---

Query Any ideas,how to generate columns dynamically using select query,please correct me ,if i am wrong.

Answer 1

Waitting for answers