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: |