
CREATE TABLE book_club (
	book_club_id INTEGER, 
	"Year" INTEGER, 
	"Author_or_Editor" TEXT, 
	"Book_Title" TEXT, 
	"Publisher" TEXT, 
	"Category" TEXT, 
	"Result" TEXT, 
	PRIMARY KEY (book_club_id)
)


CREATE TABLE culture_company (
	"Company_name" TEXT, 
	"Type" TEXT, 
	"Incorporated_in" TEXT, 
	"Group_Equity_Shareholding" REAL, 
	book_club_id TEXT, 
	movie_id TEXT, 
	PRIMARY KEY ("Company_name"), 
	FOREIGN KEY(book_club_id) REFERENCES book_club (book_club_id), 
	FOREIGN KEY(movie_id) REFERENCES movie (movie_id)
)


CREATE TABLE movie (
	movie_id INTEGER, 
	"Title" TEXT, 
	"Year" INTEGER, 
	"Director" TEXT, 
	"Budget_million" REAL, 
	"Gross_worldwide" INTEGER, 
	PRIMARY KEY (movie_id)
)

CREATE TABLE book_club (
	book_club_id INTEGER, 
	"Year" INTEGER, 
	"Author_or_Editor" TEXT, 
	"Book_Title" TEXT, 
	"Publisher" TEXT, 
	"Category" TEXT, 
	"Result" TEXT, 
	PRIMARY KEY (book_club_id)
)

/*
2 rows from book_club table:
book_club_id	Year	Author_or_Editor	Book_Title	Publisher	Category	Result
1	1989	Michael Nava	Goldenboy	Alyson	Gay M/SF	Won [A ]
2	1989	Donald Ward	Death Takes the Stage	St. Martin's Press	Gay M/SF	Nom
*/


CREATE TABLE culture_company (
	"Company_name" TEXT, 
	"Type" TEXT, 
	"Incorporated_in" TEXT, 
	"Group_Equity_Shareholding" REAL, 
	book_club_id TEXT, 
	movie_id TEXT, 
	PRIMARY KEY ("Company_name"), 
	FOREIGN KEY(book_club_id) REFERENCES book_club (book_club_id), 
	FOREIGN KEY(movie_id) REFERENCES movie (movie_id)
)

/*
2 rows from culture_company table:
Company_name	Type	Incorporated_in	Group_Equity_Shareholding	book_club_id	movie_id
Culture China	Corporate	China	18.77	1	2
Culture China Cargo	Joint Venture	China	49.0	2	3
*/


CREATE TABLE movie (
	movie_id INTEGER, 
	"Title" TEXT, 
	"Year" INTEGER, 
	"Director" TEXT, 
	"Budget_million" REAL, 
	"Gross_worldwide" INTEGER, 
	PRIMARY KEY (movie_id)
)

/*
2 rows from movie table:
movie_id	Title	Year	Director	Budget_million	Gross_worldwide
1	The Boondock Saints	1999	Troy Duffy	6.0	30471
2	The Big Kahuna	1999	John Swanbeck	7.0	3728888
*/
Which directors had a movie in either 1999 or 2000?
SELECT director FROM movie WHERE YEAR  =  1999 OR YEAR  =  2000
[{'Director': 'Troy Duffy'}, {'Director': 'John Swanbeck'}, {'Director': 'Anthony Hickox'}, {'Director': 'Anthony Hickox'}, {'Director': 'Jonathan Lynn'}, {'Director': 'Roger Christian'}, {'Director': 'Stephen Kay'}, {'Director': 'Christian Duguay'}, {'Director': 'Damian Lee'}]