Question 35

Film length report

Premium Access

Unlock this premium 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

***********

  • ***** * ***** ** ****** *** ****** ** ***** ** *** ********* **********: *****, ******, *** ****.
  • *** ***** ** **** ******* *****'* ******.

**********

  • *****: **** <60 *******.
  • ******: >=60 *******, *** <100 *******.
  • ****: >=100 *******

Table: film

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

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.