Question 175

Employees' email account

Premium Access

Unlock this Amazon 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
  • ***** * ***** ** ******** * ****'* ***** ******* ***** ** *** ********* *****:
  • ***** 3 ******* ** ***** ***** ****, ******** ** * ******: '.', **** *** ***** 5 ******* ** ***** **** ****.
  • *** ***** ******* **** *****, *** **** ** ***** **** ****.
  • ****** 3 *******: *****_****, ****_****, *** ***** ***** ******* (****** ** @*********.***).
  • *** ***** ******* *** ** ** ********* ** *********.
  • ** *********** ******* ********, *** ****** ********.

Table: amzn_employees

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

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.