Use SQLite to create the database named tectonicdb.sqlite. The earthquake table contains all earthquake recorded with magnitude greater than $5\mathrm{.}5$ since $1969.$ It contains $10$ important columns. The earthquake file can be obtained from earthquake.csv$.$ The structure of the earthquake table is similar to the following diagram $.$

Provide the quires and results you obtain, you can take screenshots to support your answer.

Count how many rows are there in this table with magnitude greater than $6?$

Retrieve all earthquakes that occurred on or after Feb $12015$

Retrieve all earthquakes that occurred between Jan $1,2015$ and Feb$22022$

What was the largest earthquake in $2011?$

What magnitude range is covered by the earthquake records?

Count how many earthquake occurred on North Korea

Find how many earthquakes are caused by either nuclear explosion or explosion.

Find how many earthquakes are caused by nuclear explosion and earthquake

Find the most recent three earthquake caused by an explosion?