
CREATE TABLE "Acceptance" (
	"Submission_ID" INTEGER, 
	"Workshop_ID" INTEGER, 
	"Result" TEXT, 
	PRIMARY KEY ("Submission_ID", "Workshop_ID"), 
	FOREIGN KEY("Workshop_ID") REFERENCES workshop ("Workshop_ID"), 
	FOREIGN KEY("Submission_ID") REFERENCES submission ("Submission_ID")
)


CREATE TABLE submission (
	"Submission_ID" INTEGER, 
	"Scores" REAL, 
	"Author" TEXT, 
	"College" TEXT, 
	PRIMARY KEY ("Submission_ID")
)


CREATE TABLE workshop (
	"Workshop_ID" INTEGER, 
	"Date" TEXT, 
	"Venue" TEXT, 
	"Name" TEXT, 
	PRIMARY KEY ("Workshop_ID")
)

CREATE TABLE "Acceptance" (
	"Submission_ID" INTEGER, 
	"Workshop_ID" INTEGER, 
	"Result" TEXT, 
	PRIMARY KEY ("Submission_ID", "Workshop_ID"), 
	FOREIGN KEY("Workshop_ID") REFERENCES workshop ("Workshop_ID"), 
	FOREIGN KEY("Submission_ID") REFERENCES submission ("Submission_ID")
)

/*
2 rows from Acceptance table:
Submission_ID	Workshop_ID	Result
2	5	Accepted
2	3	Rejected
*/


CREATE TABLE submission (
	"Submission_ID" INTEGER, 
	"Scores" REAL, 
	"Author" TEXT, 
	"College" TEXT, 
	PRIMARY KEY ("Submission_ID")
)

/*
2 rows from submission table:
Submission_ID	Scores	Author	College
1	72.0	Steve Niehaus	Notre Dame
2	79.0	Sammy Green	Florida
*/


CREATE TABLE workshop (
	"Workshop_ID" INTEGER, 
	"Date" TEXT, 
	"Venue" TEXT, 
	"Name" TEXT, 
	PRIMARY KEY ("Workshop_ID")
)

/*
2 rows from workshop table:
Workshop_ID	Date	Venue	Name
1	August 18, 2007	London UK	ABC 2007
2	August 21, 2007	London UK	Conference 2007
*/
Count the number of submissions.
SELECT count(*) FROM submission
[{'count(*)': 10}]