Challenge project time! Use your knowledge of SQL and analyze some mockup Codecademy students data.

In order to complete this project, you should be familiar with queries, aggregate functions, and multiple table joins. Ideally, you’ve completed [Analze Data with SQL](https://www.codecademy.com/learn/paths/analyze-data-with-sql).

First, use `SELECT *` from both tables and use your knowledge of queries and aggregate functions to get to know the data:

- What are the Top 25 schools (**.edu** domains)? 
- How many **.edu** learners are located in New York?
- The `mobile_app` column contains either `mobile-user` or `NULL`. How many of these Codecademy learners are using the mobile app?

The data type of the `sign_up_at` column is `DATETIME`. It is for storing a date/time value in the database.

Notice that the values are formatted like:

`2015-01-01 18:33:52`

So the format is:

`YYYY-MM-DD HH:MM:SS`

SQLite comes with a `strftime()` function - a very powerful function that allows you to return a formatted date.

It takes two arguments:

`strftime(format, column)`

Let’s test this function out:

```sql
SELECT sign_up_at,
   strftime('%S', sign_up_at)
FROM users
GROUP BY 1
LIMIT 20;
```

Now, using this function, query for the sign up counts for each hour.

Open in the hints for more info.

Join the two tables using `JOIN` and then see what you can dig out of the data!

- Do different schools (**.edu** domains) prefer different courses?
- What courses are the New Yorkers students taking?
- What courses are the Chicago students taking?

Great work! Visit [our forums](https://discuss.codecademy.com/t/codecademy-learners-challenge-project-sql/462387) to compare your project to our sample solution code. You can also learn how to host your own solution on GitHub so you can share it with other learners! Your solution might look different from ours, and that's okay! There are multiple ways to solve these projects, and you'll learn more by seeing others' code.

To experiment with the solution code, [open it in DB Browser](https://www.codecademy.com/articles/running-sql-commands-in-db-browser) if you are working on your own computer, or you can copy and paste the text from the **.sql** file into the SQL code editor here in the project.

Codecademy Learners Mockup Data

ENDING SOON: 50% off annual Pro memberships with code [FUTURE](https://www.codecademy.com/checkout?plan_id=proGoldAnnualV2&discountCode=FUTURE&plan_type=pro)