☑Kizspy.me
Display store_id, store_name, and sum of quantity in stock of the store which has the highest
sum of quantity in stock.
store_id
1
3
store_name
Rowlett Bikes
Qty in Stock
3974
Picture 7.1
Class: IA1901, SE1901, SE1902, SE1903, SE1904, SE1905
Practical Paper
4 of 4
Question 8:
Paper No: 1
Create a trigger named trgUpdateRequired Date on the required_date column of the orders
table to ensure that required_date is not earlier than order_date. However, if the required_date
is valid, it will take effect, and the data will be updated.
For example, when the following statement is executed, the output will appear as shown in
the following figure:
Zoom
+125%
Close
