Question: Write the SQL statement that would be able to: i. than 14000 name ii. iii. named tax: Define a table constraint that would ensure
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
Step by Step Solution
3.29 Rating (161 Votes )
There are 3 Steps involved in it
1 ALTER TABLE DriverInfo ADD CHECKsalary14000 If the table is not formed then use the below quer... View full answer
Get step-by-step solutions from verified subject matter experts
