A blog series for PHP developers working on larger-than-average Laravel projects
Written for projects with a development lifespan of six to twelve months, with a team of three to six developers working on them simultaneously.
| /*App usage data are kept in the following table: | |
| TABLE sessions | |
| id INTEGER PRIMARY KEY, | |
| userId INTEGER NOT NULL, | |
| duration DECIMAL NOT NULL | |
| Write a query that selects userId and average session duration for each user who has more than one session.*/ | |
| -- Example case create statement: |