### Database Schema:
CREATE TABLE foreign_data (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	flavorText	TEXT	NULL,
	language	TEXT	NULL,
	multiverseid	INTEGER	NULL,
	name	TEXT	NULL,
	text	TEXT	NULL,
	type	TEXT	NULL,
	uuid	TEXT	NULL,
	foreign key (uuid) references cards (uuid)
);

CREATE TABLE rulings (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	date	DATE	NULL,
	text	TEXT	NULL,
	uuid	TEXT	NULL,
	foreign key (uuid) references cards (uuid)
);

CREATE TABLE set_translations (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	language	TEXT	NULL,
	setCode	TEXT	NULL,
	translation	TEXT	NULL,
	foreign key (setCode) references sets (code)
);

CREATE TABLE cards (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	artist	TEXT	NULL,
	asciiName	TEXT	NULL,
	availability	TEXT	NULL,
	borderColor	TEXT	NULL,
	cardKingdomFoilId	TEXT	NULL,
	cardKingdomId	TEXT	NULL,
	colorIdentity	TEXT	NULL,
	colorIndicator	TEXT	NULL,
	colors	TEXT	NULL,
	convertedManaCost	REAL	NULL,
	duelDeck	TEXT	NULL,
	edhrecRank	INTEGER	NULL,
	faceConvertedManaCost	REAL	NULL,
	faceName	TEXT	NULL,
	flavorName	TEXT	NULL,
	flavorText	TEXT	NULL,
	frameEffects	TEXT	NULL,
	frameVersion	TEXT	NULL,
	hand	TEXT	NULL,
	hasAlternativeDeckLimit	INTEGER	NOT NULL	DEFAULT 0,
	hasContentWarning	INTEGER	NOT NULL	DEFAULT 0,
	hasFoil	INTEGER	NOT NULL	DEFAULT 0,
	hasNonFoil	INTEGER	NOT NULL	DEFAULT 0,
	isAlternative	INTEGER	NOT NULL	DEFAULT 0,
	isFullArt	INTEGER	NOT NULL	DEFAULT 0,
	isOnlineOnly	INTEGER	NOT NULL	DEFAULT 0,
	isOversized	INTEGER	NOT NULL	DEFAULT 0,
	isPromo	INTEGER	NOT NULL	DEFAULT 0,
	isReprint	INTEGER	NOT NULL	DEFAULT 0,
	isReserved	INTEGER	NOT NULL	DEFAULT 0,
	isStarter	INTEGER	NOT NULL	DEFAULT 0,
	isStorySpotlight	INTEGER	NOT NULL	DEFAULT 0,
	isTextless	INTEGER	NOT NULL	DEFAULT 0,
	isTimeshifted	INTEGER	NOT NULL	DEFAULT 0,
	keywords	TEXT	NULL,
	layout	TEXT	NULL,
	leadershipSkills	TEXT	NULL,
	life	TEXT	NULL,
	loyalty	TEXT	NULL,
	manaCost	TEXT	NULL,
	mcmId	TEXT	NULL,
	mcmMetaId	TEXT	NULL,
	mtgArenaId	TEXT	NULL,
	mtgjsonV4Id	TEXT	NULL,
	mtgoFoilId	TEXT	NULL,
	mtgoId	TEXT	NULL,
	multiverseId	TEXT	NULL,
	name	TEXT	NULL,
	number	TEXT	NULL,
	originalReleaseDate	TEXT	NULL,
	originalText	TEXT	NULL,
	originalType	TEXT	NULL,
	otherFaceIds	TEXT	NULL,
	power	TEXT	NULL,
	printings	TEXT	NULL,
	promoTypes	TEXT	NULL,
	purchaseUrls	TEXT	NULL,
	rarity	TEXT	NULL,
	scryfallId	TEXT	NULL,
	scryfallIllustrationId	TEXT	NULL,
	scryfallOracleId	TEXT	NULL,
	setCode	TEXT	NULL,
	side	TEXT	NULL,
	subtypes	TEXT	NULL,
	supertypes	TEXT	NULL,
	tcgplayerProductId	TEXT	NULL,
	text	TEXT	NULL,
	toughness	TEXT	NULL,
	type	TEXT	NULL,
	types	TEXT	NULL,
	uuid	TEXT	NOT NULL,
	variations	TEXT	NULL,
	watermark	TEXT	NULL
);

CREATE TABLE sets (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	baseSetSize	INTEGER	NULL,
	block	TEXT	NULL,
	booster	TEXT	NULL,
	code	TEXT	NOT NULL,
	isFoilOnly	INTEGER	NOT NULL	DEFAULT 0,
	isForeignOnly	INTEGER	NOT NULL	DEFAULT 0,
	isNonFoilOnly	INTEGER	NOT NULL	DEFAULT 0,
	isOnlineOnly	INTEGER	NOT NULL	DEFAULT 0,
	isPartialPreview	INTEGER	NOT NULL	DEFAULT 0,
	keyruneCode	TEXT	NULL,
	mcmId	INTEGER	NULL,
	mcmIdExtras	INTEGER	NULL,
	mcmName	TEXT	NULL,
	mtgoCode	TEXT	NULL,
	name	TEXT	NULL,
	parentCode	TEXT	NULL,
	releaseDate	DATE	NULL,
	tcgplayerGroupId	INTEGER	NULL,
	totalSetSize	INTEGER	NULL,
	type	TEXT	NULL
);

CREATE TABLE legalities (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	format	TEXT	NULL,
	status	TEXT	NULL,
	uuid	TEXT	NULL,
	foreign key (uuid) references cards (uuid)
);

### User's Query:
How many cards with print rarity have ruling text printed on 01/02/2007?

### Extra Knowledge:
with print rarity refers to rarity = 'rare'; on 01/02/2007 refers to date = '2007-02-01'
SELECT COUNT(DISTINCT T1.id) FROM cards AS T1 INNER JOIN rulings AS T2 ON T1.uuid = T2.uuid WHERE T1.rarity = 'rare' AND T2.date = '2007-02-01'