SQL to execute

query.sql

SELECT "primary"."NDC" as "primaryNDC",
       "generic"."NDC" as "genericNDC",
       "primary"."MONY",
       "primary"."ProductName" as "primaryDrug",
       "generic"."ProductName" as "genericDrug",
       "primary"."Strength",
       "primary"."StrengthUOM",

FROM "drugs" AS "primary",
     "drugs" AS "generic"

WHERE ("primary"."TpaRestrictionCode" IS NULL OR "primary"."TpaRestrictionCode" NOT IN (3, 4, 'B', 'L'))
  AND "primary"."RouteOfAdministration" IN ('IJ', 'SC')
  AND "primary"."DoseForm" IN ('INJ', 'SUSP', 'SOLR', 'SOLN')
  AND "primary"."GPI" = "generic"."GPI"
  AND  ( "primary"."DrugName" LIKE '%insulin%' OR "primary"."GenericName" LIKE '%insulin%' );