CS 101 - Lab10 Worksheet

Name:


1. What types of information does Firefox manage using SQLite?  Briefly explain
the contents of two or three databases.




2. In what database and tables are your bookmarks stored?  Why do you think
Firefox stores the title and url separately?




3. Write an SQL statement that selects your bookmarks. For each one, display
only the title, url, date added (as an integer), and visit count.




4. Write an SQL statement that lists the base domain, name, and value for each
of your cookies in order of expiration date.




5. Write an SQL statement to show how many cookies you have for each domain.
Note that you will need to use the "count" function instead of sum.




6. What are the top five movies since the year 2000, in terms of adjusted
gross income?




7. What are the title, author, and year of books from Russia in the top 100?
(For convenience, you can right-click the results and "Copy Rows as CSV.")




8. What are the names and symbols of the periodic elements with an atomic mass
of more than 280? Display the results from lightest to heaviest.




9. Which of the top 15 songs were featured in the top 100 movies? (Hint: Figure
out how to join the two tables, and then use AND clauses to filter by rank.)