Table 1.

The examples of the query criteria in GLIF3.5 and the corresponding translated SQL queries.

Query criteria format	Query criteria
GLIF3.5	1. ICD9=155.0
Translated SQL queries	1. select Personal_ID from Diagnosis where ICD9_Code=“155.0”
GLIF3.5	2. at least 2 of (Ascites==“Controllable,” ICG is within 15 to 40, Prothrombin_Activity is within 50 to 80, Serum_Albumin is within 3.0 to 3.5, Serum_Bilirubin is within 2.0 to 3.0)
Translated SQL queries	2.1. select Personal_ID from Laboratory where Result_String=“Controllable” and Item_Name=“Ascites” 2.2. select Personal_ID from Laboratory where Result_Nubmer between 15 and 40 and Item_Name=“ICG” 2.3. select Personal_ID from Laboratory where Result_Nubmer between 50 and 80 and Item_Name=“Prothrombin activity” 2.4. select Personal_ID from Laboratory where Result_Nubmer between 3.0 and 3.5 and Item_Name=“Serum albumin” 2.5. select Personal_ID from Laboratory where Result_Nubmer between 2.0 and 3.0 and Item_Name=“Serum bilirubin”