LAB
-
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..
-
7.6 LAB - Select employees and managers with inner join데이터베이스 시스템 2024. 11. 12. 09:24
The Employee table has the following columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string ManagerID - integer Write a statement that selects employees' first name and their managers' first name. Select only employees that have a manager. Order the result by employee first name. Use aliases to name the result columns Employee and Manager. Hint: J..
-
7.5 LAB - Select lesson schedule with multiple joins데이터베이스 시스템 2024. 11. 11. 09:50
LAB activityThe database has three tables for tracking horse-riding lessons:The Horse table has columns:ID - primary keyRegisteredNameBreedHeightBirthDateThe Student table has columns:ID - primary keyFirstNameLastNameStreetCityStateZipPhoneEmailAddressThe LessonSchedule table has columns:HorseID - foreign key references HorseStudentID - foreign key references StudentLessonDateTime - datetimePri..
-
7.4 LAB - Select lesson schedule with inner join데이터베이스 시스템 2024. 11. 10. 09:43
LAB activityThe database has three tables for tracking horse-riding lessons: The Horse table has columns:ID - primary keyRegisteredNameBreedHeightBirthDateThe Student table has columns:ID - primary keyFirstNameLastNameStreetCityStateZipPhoneEmailAddressThe LessonSchedule table has columns:HorseID - foreign key references HorseStudentID - foreign key references StudentLessonDateTime - datetimePri..
-
7.3 LAB - Select movie ratings with left join데이터베이스 시스템 2024. 11. 9. 10:24
LAB activityThe Movie table has the following columns:ID - integer, primary keyTitle - variable-length stringGenre - variable-length stringRatingCode - variable-length stringYear - integerThe Rating table has the following columns:Code - variable-length string, primary keyDescription - variable-length stringWrite a statement that selects movie title, year, and description. Select all movies, inc..