Naufan uxdiin

## index.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                uxdiin
                / index.md
            
            
              Created
              April 16, 2021 09:24
                — forked from meigwilym/index.md
            
              
                Notes on stitcher.io's Laravel beyond CRUD
              
          
    Laravel beyond CRUD

stitcher.io

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.
Chapter 1: Domain oriented Laravel


## app_session.sql
/*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:
	/*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: