Spring 2012 DISC In Class Queries

Database: [[Media:Spring_2012_DISC_210_database.txt|database.txt]]


 * 1) How many words do people tweet on average about Apple?
 * 2) How many words do people tweet on average about Microsoft?
 * 3) Combine the previous two queries in one query.
 * 4) What is the minimum number of words in a tweet for Apple?
 * 5) What are the tweets with the maximum number of words?
 * 6) Are there any users with multiple tweets about Apple?
 * 7) Are there any users that tweet about both Microsoft and Apple?
 * 8) Find the user(s) with the biggest tweet.
 * 9) Redo problem number 3 with the UNION operator.
 * 10) Come up with a query that uses the intersection operator
 * 11) What are some other questions you would like to ask the database?