Write the SQL statement that would be able to: i. than 14000 name ii. iii. named...

  

Transcribed Image Text:

Write the SQL statement that would be able to: i. than 14000 name ii. iii. named tax: Define a table constraint that would ensure that every value in the salary field is greater (4marks) Extract the two characters starting from the second character of the drivers (2marks) Computer ta at a rate of 8% for those earning over 30,000 and display output in a field (4marks) ? The following is a table named drivers in a database with details of drivers in KCA University. Use it to answer the questions that follow: Driver ID Drivers name 601 Mary David 602 603 604 605 Mathew Collins Andrew Age 45 47 32 44 37 Salary 20000 33000 45000 22000 15000 Write the SQL statement that would be able to: i. than 14000 name ii. iii. named tax: Define a table constraint that would ensure that every value in the salary field is greater (4marks) Extract the two characters starting from the second character of the drivers (2marks) Computer ta at a rate of 8% for those earning over 30,000 and display output in a field (4marks) ? The following is a table named drivers in a database with details of drivers in KCA University. Use it to answer the questions that follow: Driver ID Drivers name 601 Mary David 602 603 604 605 Mathew Collins Andrew Age 45 47 32 44 37 Salary 20000 33000 45000 22000 15000

Answer rating: 100% (QA)

1 ALTER TABLE DriverInfo ADD CHECKsalary14000 If the table is not formed then use the below quer... View the full answer