SELECT

section$\_$name,

MAX$($IF$($EXTRACT$($YEAR FROM trunc$\_$month$)=2024$ AND EXTRACT$($MONTH FROM trunc$\_$month$)=1,$ total$\_$distinct$\_$users, NULL$))$ AS January$\_2024,$

MAX$($IF$($EXTRACT$($YEAR FROM trunc$\_$month$)=2024$ AND EXTRACT$($MONTH FROM trunc$\_$month$)=2,$ total$\_$distinct$\_$users, NULL$))$ AS February$\_2024,$

MAX$($IF$($EXTRACT$($YEAR FROM trunc$\_$month$)=2024$ AND EXTRACT$($MONTH FROM trunc$\_$month$)=3,$ total$\_$distinct$\_$users, NULL$))$ AS March$\_2024,$

MAX$($IF$($EXTRACT$($YEAR FROM trunc$\_$month$)=2024$ AND EXTRACT$($MONTH FROM trunc$\_$month$)=4,$ total$\_$distinct$\_$users, NULL$))$ AS April$\_2024,$

MAX$($IF$($EXTRACT$($YEAR FROM trunc$\_$month$)=2024$ AND EXTRACT$($MONTH FROM trunc$\_$month$)=5,$ total$\_$distinct$\_$users, NULL$))$ AS May$\_2024,$

MAX$($IF$($EXTRACT$($YEAR FROM trunc$\_$month$)=2024$ AND EXTRACT$($MONTH FROM trunc$\_$month$)=6,$ total$\_$distinct$\_$users, NULL$))$ AS June$\_2024,$

MAX$($IF$($EXTRACT$($YEAR FROM trunc$\_$month$)=2024$ AND EXTRACT$($MONTH FROM trunc$\_$month$)=7,$ total$\_$distinct$\_$users, NULL$))$ AS July$\_2024,$

MAX$($IF$($EXTRACT$($YEAR FROM trunc$\_$month$)=2024$ AND EXTRACT$($MONTH FROM trunc$\_$month$)=8,$ total$\_$distinct$\_$users, NULL$))$ AS August$\_2024,$

MAX$($IF$($EXTRACT$($YEAR FROM trunc$\_$month$)=2024$ AND EXTRACT$($MONTH FROM trunc$\_$month$)=9,$ total$\_$distinct$\_$users, NULL$))$ AS September$\_2024,$

MAX$($IF$($EXTRACT$($YEAR FROM trunc$\_$month$)=2024$ AND EXTRACT$($MONTH FROM trunc$\_$month$)=10,$ total$\_$distinct$\_$users, NULL$))$ AS October$\_2024,$

MAX$($IF$($EXTRACT$($YEAR FROM trunc$\_$month$)=2024$ AND EXTRACT$($MONTH FROM trunc$\_$month$)=11,$ total$\_$distinct$\_$users, NULL$))$ AS November$\_2024,$

MAX$($IF$($EXTRACT$($YEAR FROM trunc$\_$month$)=2024$ AND EXTRACT$($MONTH FROM trunc$\_$month$)=12,$ total$\_$distinct$\_$users, NULL$))$ AS December$\_2024,$

FROM

production$\_$data.feb$\_2024\_$overall$\_$feature$\_$usage

GROUP BY

section$\_$name

order by section$\_$name

$----$

In this code I am transposing month names from rows to columns, which is a pivot. Now, I want to change this to remove all column names which are months from the future. I am using bigquery.