Cacher is the code snippet organizer for pro developers

select
	count(*),
	date_trunc( 'month', submitteddate) as months
from
(SELECT
    identifier,
 	  producttype,
    submitteddate,
    status as substatus,
    metasubmit.albumlabelordernumber,
 	jsonb_array_elements(jsonb_array_elements(form::JSONB #>'{trackView}') #> '{tracks}') as tracks
    from metasubmit
    inner join
    (SELECT
      max(submitteddate) as max_date,
      albumlabelordernumber
      from metasubmit
	 where status like 'approved'
      group by albumlabelordernumber
    ) as max_date
    on
      max_date.max_date = metasubmit.submitteddate and
      max_date.albumlabelordernumber = metasubmit.albumlabelordernumber
) as all_tracks
	WHERE NOT (producttype = ANY (array['CD','LP','12','7']))
group by date_trunc( 'month', submitteddate)
order by months