### Database Schema:
CREATE TABLE event (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	sport_id	INTEGER	NULL	DEFAULT NULL,
	event_name	TEXT	NULL	DEFAULT NULL,
	foreign key (sport_id) references sport (id)
);

CREATE TABLE noc_region (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	noc	TEXT	NULL	DEFAULT NULL,
	region_name	TEXT	NULL	DEFAULT NULL
);

CREATE TABLE sport (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	sport_name	TEXT	NULL	DEFAULT NULL
);

CREATE TABLE games (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	games_year	INTEGER	NULL	DEFAULT NULL,
	games_name	TEXT	NULL	DEFAULT NULL,
	season	TEXT	NULL	DEFAULT NULL
);

CREATE TABLE games_competitor (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	games_id	INTEGER	NULL	DEFAULT NULL,
	person_id	INTEGER	NULL	DEFAULT NULL,
	age	INTEGER	NULL	DEFAULT NULL,
	foreign key (games_id) references games (id),
	foreign key (person_id) references person (id)
);

CREATE TABLE city (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	city_name	TEXT	NULL	DEFAULT NULL
);

CREATE TABLE competitor_event (
	event_id	INTEGER	NULL	DEFAULT NULL,
	competitor_id	INTEGER	NULL	DEFAULT NULL,
	medal_id	INTEGER	NULL	DEFAULT NULL,
	foreign key (medal_id) references medal (id),
	foreign key (event_id) references event (id),
	foreign key (competitor_id) references games_competitor (id)
);

CREATE TABLE medal (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	medal_name	TEXT	NULL	DEFAULT NULL
);

CREATE TABLE games_city (
	games_id	INTEGER	NULL	DEFAULT NULL,
	city_id	INTEGER	NULL	DEFAULT NULL,
	foreign key (games_id) references games (id),
	foreign key (city_id) references city (id)
);

CREATE TABLE person (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	full_name	TEXT	NULL	DEFAULT NULL,
	gender	TEXT	NULL	DEFAULT NULL,
	height	INTEGER	NULL	DEFAULT NULL,
	weight	INTEGER	NULL	DEFAULT NULL
);

CREATE TABLE person_region (
	person_id	INTEGER	NULL	DEFAULT NULL,
	region_id	INTEGER	NULL	DEFAULT NULL,
	foreign key (person_id) references person (id),
	foreign key (region_id) references noc_region (id)
);

### User's Query:
How many athletes playing in Canoeing fall into overweight BMI category in the 2008 Summer games?

### Extra Knowledge:
fall into overweight BMI category refers to DIVIDE(weight), MULTIPLY(height, height) < 30; Canoeing refers to a sport name; the 2008 Summer games refer to games_name = '2008 Summer';
SELECT COUNT(T5.id) FROM sport AS T1 INNER JOIN event AS T2 ON T1.id = T2.sport_id INNER JOIN competitor_event AS T3 ON T2.id = T3.event_id INNER JOIN games_competitor AS T4 ON T3.competitor_id = T4.id INNER JOIN person AS T5 ON T4.person_id = T5.id INNER JOIN games AS T6 ON T4.games_id = T6.id WHERE T1.sport_name = 'Canoeing' AND T6.games_name = '2008 Summer' AND T5.weight * 10000.0 / (T5.height * T5.height) BETWEEN 25.0 AND 30