Open jmelot opened 1 month ago
select cset_id, name, all_pubs from ai_companies_visualization.all_visualization_data where all_pubs > 1 and array_length(ror_id) = 0 and name not in (select split(name, " (")[0] from gcp_cset_ror.ror) order by all_pubs desc
select cset_id, name, all_pubs from ai_companies_visualization.all_visualization_data where all_pubs > 1 and array_length(ror_id) = 0 and name not in (select split(name, " (")[0] from gcp_cset_ror.ror) order by all_pubs desc