Connecting database with SQLite

The data is from the happiness index and can be found here.

Goals:

• Connect to a SQL database
• Perform CRUD operations:
  • A table was created used the link mentioned above.
  • Values were insserted into the table.
• Write at least two different SQL queries
  • The first query print the first 10 rows of the table who had the support values higher than the average of the countries analyzed.
  • The second query returns all the countries that start with A.

Test:

A test is made to see if the database is connected.

The process flow

Query Screenshot