Move from intermediate tables to "IN" clause

[zimolzak]

On a recent data call, there was a request to avoid "re-creating dim tables" repeatedly, but rather to use more "IN" clauses or other alternative constructs. This would affect approximately lines 1–2002 of Lung.sql and lines 1–1636 of Fobt.sql. The change would result in far fewer CREATE TABLE and INSERT INTO lines. It would also mean a radical change in the current structure of the code base.

instruct-project-etrigger-sql/Lung.sql

Line 201 in 0b4d07d

( 'CT','','71275')

instruct-project-etrigger-sql/Fobt.sql

Line 219 in 0b4d07d

select 'PrevColonCancer','ColonCancer','154.0'