3a) Write an SQL command that will create Policies table which shown in below. Policies PolCode 11223 PolName Life insur
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
3a) Write an SQL command that will create Policies table which shown in below. Policies PolCode 11223 PolName Life insur
Question 3(a) table: policy code = 5054, policy name = Saving, policy unit = 8, policy cost = 2000.15. (5 marks) 3c) Write an SQL command to give Life insurance policy name 20% discount. (5 marks)
3a) Write an SQL command that will create Policies table which shown in below. Policies PolCode 11223 PolName Life insurance PolUnit PolCost 1500.50 3 (5 marks) 3b) Write an SQL command to insert the following information into the