Software Carpentry Day 9: Databases

Morning

Please download molecules.sql and use it to create a small SQLite database, then write queries to answer the following questions:

1. What atoms have an atomic weight greater than 15?
2. What molecules use more than 4 hydrogen atom?
3. What atoms are used in ammonia?
4. What atoms are used in either ammonia or water?

Afternoon

1. How many atoms are there?
2. How many molecules are there?
3. What atoms are used in at least one molecule?
4. What atoms are not used in any molecules?