The SQL query of calculating hourly sofa score in eICU database: https://eicu-crd.mit.edu/, originally from Xiaoli Liu.
First of all, create a new dataset inside your project.
Select your dataset name.
Change "db_name" inside Xiaoli's code into your unique dataset name. For example:
drop table if exists `db_name.weight_icustay_detail_modify_eicu`;
create table `db_name.weight_icustay_detail_modify_eicu` as
drop table if exists `alert-basis-349808.eICUsofa.weight_icustay_detail_modify_eicu`;
create table `alert-basis-349808.eICUsofa.weight_icustay_detail_modify_eicu` as
Run "weight_icustay_detail_modify_eicu.sql" first, next the other six queries other than "pivoted_sofa_eicu.sql". And finally "pivoted_sofa_eicu.sql".