added the database schema. Tested queries on local database. Results successful.