This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /*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: |