Question 165

Session stitching

Premium Access

Unlock this Walmart interview question.

Sign in or upgrade to practice this question with full datasets, official solutions, and guided walkthroughs.

  • 230+ interview questions
  • Official solutions
  • SQL, Python, and R tracks
  • ** * **** ***** **** ** ****** 5 *******, ** **** ** ******* *** *** ******** *** **** **** *** ***** (*******) *******_** ** ********* *** **** ********.
  • *.*., ** * **** ****** ** ** 1 ** *** *** ***** * ***_*******_** 1, ****** **** ** ***** ** 1:03 ** **** * ***_*******_** 2, ** **** ** ****** *** ***_*******_** 2 *** **** **** ***_*******_** 1.
  • *.*., ** * **** ****** ** ** 1 ** *** *** ***** * ***_*******_** 1, ****** **** ** ***** ** 1:03 ** **** * ***_*******_** 2,  *** ****** **** ** ***** ** 1:07, ** **** ** ****** **** ******** 2 *** 3 ******* *** *** ** *** **** *******.
  • ** * **** ****** ** ** 1 ** *** ****** **** ** ** 1:06 **, ** **** *** ****** *** *******.
  • *** *** *** *******(***** **** **_2 - **_1)/60 ** *** *** ****** ** ******* ******* 2 **** ******: **_1 *** **_2, ***** **_2 > **_1.

Table: walmart_logins

***** **** * **** **** ** ** *******.***, ** **** * ******** *** *** * *** ***_*******_**

  ***_****      | ***_****
----------------+-------------------
****_**         | ******
*****_**        | *********
***_*******_**  | ******

Sample results


        
    

Last Submission

postgres

No submission yet for this engine. Run and submit your query to save it here.

Copied
Expected results

Submit a query to compare against expected output.