### Database Schema:
CREATE TABLE historical (
	ballotpedia_id	TEXT	NULL,
	bioguide_id	TEXT	NULL	PRIMARY KEY,
	bioguide_previous_id	TEXT	NULL,
	birthday_bio	TEXT	NULL,
	cspan_id	TEXT	NULL,
	fec_id	TEXT	NULL,
	first_name	TEXT	NULL,
	gender_bio	TEXT	NULL,
	google_entity_id_id	TEXT	NULL,
	govtrack_id	INTEGER	NULL,
	house_history_alternate_id	TEXT	NULL,
	house_history_id	REAL	NULL,
	icpsr_id	REAL	NULL,
	last_name	TEXT	NULL,
	lis_id	TEXT	NULL,
	maplight_id	TEXT	NULL,
	middle_name	TEXT	NULL,
	nickname_name	TEXT	NULL,
	official_full_name	TEXT	NULL,
	opensecrets_id	TEXT	NULL,
	religion_bio	TEXT	NULL,
	suffix_name	TEXT	NULL,
	thomas_id	TEXT	NULL,
	votesmart_id	TEXT	NULL,
	wikidata_id	TEXT	NULL,
	wikipedia_id	TEXT	NULL
);

CREATE TABLE `social-media` (
	bioguide	TEXT	NULL	PRIMARY KEY,
	facebook	TEXT	NULL,
	facebook_id	REAL	NULL,
	govtrack	REAL	NULL,
	instagram	TEXT	NULL,
	instagram_id	REAL	NULL,
	thomas	INTEGER	NULL,
	twitter	TEXT	NULL,
	twitter_id	REAL	NULL,
	youtube	TEXT	NULL,
	youtube_id	TEXT	NULL,
	foreign key (bioguide) references current (bioguide_id)
);

CREATE TABLE current (
	ballotpedia_id	TEXT	NULL,
	bioguide_id	TEXT	NULL	PRIMARY KEY,
	birthday_bio	DATE	NULL,
	cspan_id	REAL	NULL	PRIMARY KEY,
	fec_id	TEXT	NULL,
	first_name	TEXT	NULL,
	gender_bio	TEXT	NULL,
	google_entity_id_id	TEXT	NULL,
	govtrack_id	INTEGER	NULL,
	house_history_id	REAL	NULL,
	icpsr_id	REAL	NULL,
	last_name	TEXT	NULL,
	lis_id	TEXT	NULL,
	maplight_id	REAL	NULL,
	middle_name	TEXT	NULL,
	nickname_name	TEXT	NULL,
	official_full_name	TEXT	NULL,
	opensecrets_id	TEXT	NULL,
	religion_bio	TEXT	NULL,
	suffix_name	TEXT	NULL,
	thomas_id	INTEGER	NULL,
	votesmart_id	REAL	NULL,
	wikidata_id	TEXT	NULL,
	wikipedia_id	TEXT	NULL
);

CREATE TABLE `current-terms` (
	address	TEXT	NULL,
	bioguide	TEXT	NULL	PRIMARY KEY,
	caucus	TEXT	NULL,
	chamber	TEXT	NULL,
	class	REAL	NULL,
	contact_form	TEXT	NULL,
	district	REAL	NULL,
	end	TEXT	NULL	PRIMARY KEY,
	fax	TEXT	NULL,
	last	TEXT	NULL,
	name	TEXT	NULL,
	office	TEXT	NULL,
	party	TEXT	NULL,
	party_affiliations	TEXT	NULL,
	phone	TEXT	NULL,
	relation	TEXT	NULL,
	rss_url	TEXT	NULL,
	start	TEXT	NULL,
	state	TEXT	NULL,
	state_rank	TEXT	NULL,
	title	TEXT	NULL,
	type	TEXT	NULL,
	url	TEXT	NULL,
	foreign key (bioguide) references current (bioguide_id)
);

CREATE TABLE `historical-terms` (
	address	TEXT	NULL,
	bioguide	TEXT	NULL	PRIMARY KEY,
	chamber	TEXT	NULL,
	class	REAL	NULL,
	contact_form	TEXT	NULL,
	district	REAL	NULL,
	end	TEXT	NULL,
	fax	TEXT	NULL,
	last	TEXT	NULL,
	middle	TEXT	NULL,
	name	TEXT	NULL,
	office	TEXT	NULL,
	party	TEXT	NULL,
	party_affiliations	TEXT	NULL,
	phone	TEXT	NULL,
	relation	TEXT	NULL,
	rss_url	TEXT	NULL,
	start	TEXT	NULL,
	state	TEXT	NULL,
	state_rank	TEXT	NULL,
	title	TEXT	NULL,
	type	TEXT	NULL,
	url	TEXT	NULL,
	foreign key (bioguide) references historical (bioguide_id)
);

### User's Query:
List all the junior senators in 1997.

### Extra Knowledge:
junior senators refers to state_rank = 'junior'; in 1997 refers to start like '1997%';
SELECT T1.first_name, T1.last_name FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T2.start LIKE '1997%' AND T2.state_rank = 'junior'