plant_fraction.table/make()

{

	echo_func; set_make_vars; mk_table_esc

	use_local_remote

	if remaking; then table=plant_fraction table_esc= mk_drop|mysql_ANSI; fi

	mysql_ANSI <<EOF

CREATE TABLE IF NOT EXISTS "plant_fraction" AS

SELECT

  institution_code

, COUNT(family LIKE '%aceae%' OR family IN ('Compositae','Gramineae','Palmae','Guttiferae','Cruciferae','Labiatae','Umbelliferae','Leguminosae'))/COUNT(*)

	AS plant_fraction

FROM ${limit:+(SELECT * FROM }$table_esc ${limit:+$(prefix= limit)) s}

GROUP BY institution_code

ORDER BY institution_code

EOF

}