Consider the following table: Movies with primary key id: BoxOffice with primary key Movie_id, and foreign key also Movie_id (referencing Movies of question 1 given before). BoxOffice Movie_id Rating Domestic sales International sales 5 8.2 380843261 555900000 475066843 14 7.4 268492764 8 8 206445654 417277164 12 6.4 191452396 368400000 3 7.9 245852179 239163000 6 8 261441092 370001000 Write a query in SQL to create table BoxOffice while identifying the following: * Column names and each column domain/type * primary key constraints * foreign key constraints * Rating to be NOT NULL