
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
*/
Show all movie titles, years, and directors, ordered by budget.
SELECT title ,  YEAR ,  director FROM movie ORDER BY budget_million
[{'Title': 'Jill Rips', 'Year': 2000, 'Director': 'Anthony Hickox'}, {'Title': 'Storm Catcher', 'Year': 1999, 'Director': 'Anthony Hickox'}, {'Title': 'The Boondock Saints', 'Year': 1999, 'Director': 'Troy Duffy'}, {'Title': 'The Big Kahuna', 'Year': 1999, 'Director': 'John Swanbeck'}, {'Title': 'The Whole Nine Yards', 'Year': 2000, 'Director': 'Jonathan Lynn'}, {'Title': 'Battlefield Earth', 'Year': 2000, 'Director': 'Roger Christian'}, {'Title': 'Agent Red', 'Year': 2000, 'Director': 'Damian Lee'}, {'Title': 'The Art of War', 'Year': 2000, 'Director': 'Christian Duguay'}, {'Title': '3000 Miles to Graceland', 'Year': 2001, 'Director': 'Demian Lichtenstein'}, {'Title': 'Get Carter', 'Year': 2000, 'Director': 'Stephen Kay'}]