In this assignment we are going to work with a larger collection of tweets (10,000) that are available here: http://rasinsrv07.cstcis.cti.depaul.edu/CSC455/Assignment5.txt

a.Write and execute a SQL query to do the following: Find the user (id and name) with the minimum friend_count in the database

b. Write python code that is going to perform the same computation (find the user with the minimum friend_count)

c. Write and execute SQL query to do the following: Find the tweets without associated geo entry (hint: it should involve a NULL).

d. Write python code that is going to perform the same computation as 2-c. e. Write and execute SQL query that finds the longest and the shortest tweet text message (if there is a tie, you must return all shortest and longest tweet messages, not just one).