Reply
  • Hey guys, wondering how you would answer a question like this?

    I’m pretty new to SQL and want to study up for a job interview coming up

    Application usage data is kept in the
    following table:

    Table sessions: Id, userld, duration, data_timestamp

    Write a query that selects userld and average session duration for each "Good User"

    Good User- a user with an average of at least 3 sessions in a week