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 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 5 14 8 00 12 3 6 Rating 8.2 7.4 8 6.4 7.9 8 Domestic_sales 380843261 268492764 206445654 191452396 245852179 261441092 International_sales 555900000 475066843 417277164 368400000 239163000 370001000