Skip to content

Instantly share code, notes, and snippets.

View basilcea's full-sized avatar

Ogbonna Basil basilcea

  • Anywhere
View GitHub Profile
@basilcea
basilcea / app_session.sql
Created June 3, 2022 08:20 — forked from mindyng/app_session.sql
TestDome SQL Practice Q's
/*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: