Round
-
7.7 LAB - Multiple joins with aggregate (Sakila)데이터베이스 시스템 2024. 11. 13. 04:57
Refer to the film, actor, and film_actor tables of the Sakila database. The tables in this lab have the same columns and data types but fewer rows. The tables are initialized with LOAD rather than INSERT statements. The LOAD statements read data from .csv files. In these files, \N represents NULL.Write a statement that:Computes the average length of all films that each actor appears in.Rounds av..