In this task you are given a set of transactions. There are multiple requirements for which you need to write queries.
Results of queries must contain the requested columns with names used as column names and nothing else.
You have 2 tables:
player (id, transaction FK) // CREATE TABLE IF NOT EXISTS player ...
transaction (id INT, type STING, amount INT, created_at DATE) CREATE TABLE IF NOT EXISTS transaction ...
Create a query that returns list with first deposits of each player in ascending order by transaction creation date.
Deposit is a transaction with type = "deposit" .
List must have following columns:
name => transaction.type
week_day => week day names like "Monday"
count => transaction count