Here is my code SELECT section name, MAX ( IF ( EXTRACT ( YEAR FROM trunc month ) 2 0 2 4 AND EXTRACT ( MONTH FROM trunc month ) 1 , total distinct users, NULL ) ) AS January 2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc month ) 2 0 2 4 AND EXTRACT ( MONTH FROM trunc month ) 2 , total distinct users, NULL ) ) AS February 2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc month ) 2 0 2 4 AND EXTRACT ( MONTH FROM trunc month ) 3 , total distinct users, NULL ) ) AS March 2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc month ) 2 0 2 4 AND EXTRACT ( MONTH FROM trunc month ) 4 , total distinct users, NULL ) ) AS April 2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc month ) 2 0 2 4 AND EXTRACT ( MONTH FROM trunc month ) 5 , total distinct users, NULL ) ) AS May 2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc month ) 2 0 2 4 AND EXTRACT ( MONTH FROM trunc month ) 6 , total distinct users, NULL ) ) AS June 2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc month ) 2 0 2 4 AND EXTRACT ( MONTH FROM trunc month ) 7 , total distinct users, NULL ) ) AS July 2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc month ) 2 0 2 4 AND EXTRACT ( MONTH FROM trunc month ) 8 , total distinct users, NULL ) ) AS August 2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc month ) 2 0 2 4 AND EXTRACT ( MONTH FROM trunc month ) 9 , total distinct users, NULL ) ) AS September 2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc month ) 2 0 2 4 AND EXTRACT ( MONTH FROM trunc month ) 1 0 , total distinct users, NULL ) ) AS October 2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc month ) 2 0 2 4 AND EXTRACT ( MONTH FROM trunc month ) 1 1 , total distinct users, NULL ) ) AS November 2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc month ) 2 0 2 4 AND EXTRACT ( MONTH FROM trunc month ) 1 2 , total distinct users, NULL ) ) AS December 2 0 2 4 , FROM production data feb 2 0 2 4 overall feature usage GROUP BY section name order by section name How do I remove the columns with NULLS in all rows ( i e the future months )

Question

Here is my code  SELECT section   name, MAX ( IF ( EXTRACT ( YEAR FROM trunc   month )   2 0 2 4 AND EXTRACT ( MONTH FROM trunc   month )   1 , total   distinct   users, NULL ) ) AS January   2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc   month )   2 0 2 4 AND EXTRACT ( MONTH FROM trunc   month )   2 , total   distinct   users, NULL ) ) AS February   2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc   month )   2 0 2 4 AND EXTRACT ( MONTH FROM trunc   month )   3 , total   distinct   users, NULL ) ) AS March   2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc   month )   2 0 2 4 AND EXTRACT ( MONTH FROM trunc   month )   4 , total   distinct   users, NULL ) ) AS April   2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc   month )   2 0 2 4 AND EXTRACT ( MONTH FROM trunc   month )   5 , total   distinct   users, NULL ) ) AS May   2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc   month )   2 0 2 4 AND EXTRACT ( MONTH FROM trunc   month )   6 , total   distinct   users, NULL ) ) AS June   2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc   month )   2 0 2 4 AND EXTRACT ( MONTH FROM trunc   month )   7 , total   distinct   users, NULL ) ) AS July   2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc   month )   2 0 2 4 AND EXTRACT ( MONTH FROM trunc   month )   8 , total   distinct   users, NULL ) ) AS August   2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc   month )   2 0 2 4 AND EXTRACT ( MONTH FROM trunc   month )   9 , total   distinct   users, NULL ) ) AS September   2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc   month )   2 0 2 4 AND EXTRACT ( MONTH FROM trunc   month )   1 0 , total   distinct   users, NULL ) ) AS October   2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc   month )   2 0 2 4 AND EXTRACT ( MONTH FROM trunc   month )   1 1 , total   distinct   users, NULL ) ) AS November   2 0 2 4 , MAX ( IF ( EXTRACT ( YEAR FROM trunc   month )   2 0 2 4 AND EXTRACT ( MONTH FROM trunc   month )   1 2 , total   distinct   users, NULL ) ) AS December   2 0 2 4 , FROM production   data feb   2 0 2 4   overall   feature   usage GROUP BY section   name order by section   name How do I remove the columns with NULLS in all rows ( i   e   the future months )

Accepted Answer

The Answer is in the image, click to view ...

Question

Here is my code: SELECT section _ name, MAX ( IF ( EXTRACT ( YEAR FROM trunc _ month ) = 2 0 2 4

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2014 Nancy France September 15 19 2014 Proceedings Part I Lnai 8724

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question