I'm new to sql/creating a pivot table as a view in Geodatabase.
I'm looking for the SQL query for the "Create New View" tool (see attached screenshot)
I tried to google many samples but it didn't work out. While I'm still googling, i thought i could ask you guys for help.
My goal is to create a VIEW (PIVOT) based on an existing table in the Geodatabase:
any direction, inputs, sample are appreciated!!!
Existing table in Geodatabase:
my goal is to create a VIEW (pivot) below based on the TABLE above