How many authors are from college "Florida"?
select count(author) from submission where college = "Florida"
How about the college "Temple"?
select count(author) from submission where college = "Temple"
What is the sum of the number of authors from these two colleges?
select count(author) from submission where college = "Florida" or college = "Temple"
Please show the authors' names.
select author from submission where college = "Florida" or college = "Temple"