Tell me the date of the journal with the theme Tampa Bay Buccaneers.
select date from journal where theme = "Tampa bay Buccaneers"
Who is its editor?
select t2.name from journal_committee as t1 join editor as t2 on t1.editor_id = t2.editor_id join journal as t3 on t1.journal_id = t3.journal_id where t3.theme = "Tampa bay Buccaneers"
I want to know the names and ages of editors and the theme of journals for which they serve on committees, in ascending alphabetical order of theme.
select t2.name, t2.age, t3.theme from journal_committee as t1 join editor as t2 on t1.editor_id = t2.editor_id join journal as t3 on t1.journal_id = t3.journal_id order by t3.theme asc