Changes

Jump to navigation Jump to search
*AllMatchc20InduTotal (RevisedDbaseCode.sql)
*rankingfull <- likely new placeyearranking
 
Code for matchinstagenarrow
CASE WHEN (dealseed >= 1 AND (firmstageprefno=1 OR firmstageprefno=3 OR firmstageprefno=5)) THEN 1::int
WHEN (dealearly >= 1 AND (firmstageprefno=2 OR firmstageprefno=3 OR firmstageprefno=5)) THEN 1::int
WHEN (deallater >= 1 AND (firmstageprefno=4 OR firmstageprefno=5)) THEN 1::int
ELSE 0::int END AS matchinstagenarrow,
==Previous Work==

Navigation menu