Click here to navigate the course.

Drag the edges to resize the window.

In Projects, you can keep track of your progress as you go throught the tasks. Check each item as you complete it!

Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.
Learn

Nice work, you just defined ARPU for Mineblocks!

In our ARPU query, we used using instead of on in the join clause. This is a special case join.

from daily_revenue join daily_players using (dt);

When the columns to join have the same name in both tables you can use using instead of on. Our use of the using keyword is in this case equivalent to this clause:

from daily_revenue join daily_players on daily_revenue.dt = daily_players.dt;
Report a Bug
If you see a bug or any other issue with this page, please report it here.