Advertisement
Guest User

Untitled

a guest
Aug 24th, 2016
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. select
  2. date_part('month', a."RPT_DATE") as month,
  3. date_part('year', a."RPT_DATE") as year,
  4. COUNT(*) as the_count
  5. from "F501_502_CD" a
  6. join "FILER_FILINGS_CD" b
  7. on a."FILING_ID" = b."FILING_ID"
  8. where a."YR_OF_ELEC" = 2016
  9. and a."FORM_TYPE" = 'F501'
  10. group by 1, 2
  11. order by 2, 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement