8 of 8 Paper No: 1
display the ProductID, ProductName, SubcategoryID, SubcategoryName, Category corresponding to the rows that have been inserted.
for example, when we execute the following statement, the results should be as in the following figure:
insert into Product(ProductID, Name, Cost, Price, SubcategoryID, SellStartDate)
values (1005, 'Product Test', 12, 15, 1, '2021-10-25')
ProductID ProductName SubcategoryID SubcategoryName Category 1005 Product Test 1
Mountain Bikes Bikes
Question 10:
Picture 9.1
[1 mark]Write a query to delete from the table Productinventory all rows corresponding to products belonging to the Model having ModelID = 33.
1
Zoom
+ 63%
Close
