afos=# select pil, source, count(*), min(entered), max(entered) from products where substr(pil, 1, 3) = 'CWF' and source in ('PAFG', 'PAJK', 'PAFC') GROUP by pil, source;
  pil   | source | count |          min           |          max           
--------+--------+-------+------------------------+------------------------
 CWF061 | PAJK   | 14580 | 1993-01-27 13:33:00+00 | 2004-10-18 19:00:00+00
 CWF068 | PAFC   |   945 | 1993-01-27 23:40:00+00 | 1994-04-02 23:45:00+00
 CWFAEG | PAJK   | 21640 | 2003-11-19 08:00:00+00 | 2025-01-04 12:55:00+00
 CWFAER | PAFC   | 23074 | 2003-09-09 19:00:00+00 | 2025-01-04 13:00:00+00
 CWFAER | PAJK   |     1 | 2003-11-19 20:00:00+00 | 2003-11-19 20:00:00+00
 CWFAFG | PAFG   |  1172 | 2004-01-13 17:21:00+00 | 2005-05-31 17:51:00+00
 CWFAJK | PAJK   | 29498 | 2003-11-19 20:00:00+00 | 2025-01-03 23:35:00+00
 CWFALU | PAFC   | 20718 | 2003-09-09 19:00:00+00 | 2025-01-04 12:55:00+00
 CWFJNU | PAJK   |  6436 | 1986-12-23 23:37:00+00 | 1993-01-27 11:55:00+00
 CWFNSB | PAFG   | 14917 | 2005-06-01 18:38:00+00 | 2025-01-04 10:41:00+00
 CWFVDZ | PAFC   |  8869 | 1994-03-09 18:43:00+00 | 2004-01-13 08:00:00+00
 CWFVWS | PAFC   |     1 | 2011-07-27 23:56:00+00 | 2011-07-27 23:56:00+00
 CWFWCZ | PAFG   | 14872 | 2005-06-01 17:39:00+00 | 2025-01-04 10:43:00+00
 CWFYAK | PAJK   |  9991 | 2010-07-01 11:36:00+00 | 2025-01-04 12:46:00+00
(14 rows)

afos=# select pil, source, count(*), min(entered), max(entered) from products where substr(pil, 1, 3) = 'OFF' and source in ('PAFG', 'PAJK', 'PAFC') GROUP by pil, source;
  pil   | source | count |          min           |          max           
--------+--------+-------+------------------------+------------------------
 OFFAER | PAFC   | 15973 | 2004-01-12 20:00:00+00 | 2025-01-04 13:01:00+00
 OFFAFG | PAFG   | 11409 | 2009-07-20 21:45:00+00 | 2025-01-04 13:00:00+00
 OFFAJK | PAJK   | 17011 | 2004-01-12 20:00:00+00 | 2025-01-04 12:48:00+00
 OFFALU | PAFC   | 16461 | 2004-01-12 20:00:00+00 | 2025-01-04 13:00:00+00
 OFFN11 | PAJK   | 18756 | 2004-10-18 19:00:00+00 | 2025-01-04 12:55:00+00
 OFFN12 | PAFC   | 21358 | 2004-10-18 19:00:00+00 | 2025-01-04 13:00:00+00
 OFFN13 | PAFC   | 19092 | 2004-10-18 16:28:00+00 | 2025-01-04 12:56:00+00
 OFFN14 | PAFG   | 14884 | 2004-10-15 19:00:00+00 | 2025-01-04 10:43:00+00
 OFFN15 | PAFG   | 14468 | 2005-06-01 18:38:00+00 | 2025-01-04 10:41:00+00
(9 rows)