n this activity, you$$ll write SQL Queries on the SQL OnLine IDE $($sqliteonline$.$com$)$ site and interpret your findings of a data set. Import the quizdata.db file to use as your source data in SQLite Online.

Answer each of the following questions by writing a SQL Query, taking a screenshot showing your query and the results, and writing an explanation of your findings.

Write a SQL query that retrieves a list of all people including their id number, first name, last name, age, and state code.

Write a SQL query that retrieves a list of all people including their id number, first name, last name, age, and state code who have a state code of CA$.$ How many rows of data are in the result $($Hint: Mouse over the table icon in the lower right corner of the page to see the number of rows$)?$

Write a SQL query that finds the first name, last name, and age of the oldest person in the people table. Is it just one person, or are there actually multiple people who are the same age?

Write a SQL query that lists the city, state code, and state name for every record in the people table $($Hint: You$$re going to need to use one of the JOIN types to get the state name from the states table$).$

Write a SQL query that finds the average quiz points value for people from the city of Los Angeles.