please answer 4 and 6

WA Insert into table sizeType, column size the distinct character portion of table product, column size using the SUBSTRING_INDEX function, the arguments passed should be column size, an explicit space and the value -1. Example SUBSTRING INDEX( 5. Alter table product, add column sizeTypeld as integer, 7 characters, not null 6. Update table product, set column sizeTypeld equal to the corresponding size in table sizeType In my size Type table I have the following: 1 ounce 21 pound 3 count For example, all rows with size equal to size containing the text "ounce" set sizeTypeld equal to 1 Hint: use the LIKE comparison operator 7. Alter table product add foreign key for column sizeTypeId references table sizeType, column ID 8. Update table product, set size equal to the number portion of the data in column size using the SUBSTRING_INDEX function, the arguments passed should be column size, an explicit space and the value 1. Example SUBSTRING_INDEX( 1) 9. Alter table product to modify column size to be decimal 7 characters, 2 to the right of the decimal point, not null 10. Insert into table product the data in file product.sql 11. Generate an ER Diagram using MySQL Workbench, save as a mwb file 12. Export database frozen food using MySQL Workbench, save as a.sql file 13. Provide written source code in a sql file Test Cases Test Case 1 Table size Type should look similar to Figure 1 D Focus 542 Words