TeamViewer
6 of 6
Paper No: 1
The system will display the result "inserted" if a new employee is inserted, otherwise "noinsert"
for example, when you execute the following statement, the system will display the results as in the following figure:
insert dbo.EMPLOYEE values('Tester','T', 'Tester', 000111000, '2023/03/07', 'testing', 'F', 40000,987654321,5)
the result
no insert
Picture 9.1
Question 10:
Write a query to increase employee salary by an additional 10% if he/she has at least 1 dependent under 18 years old.
+ 85%
Zoom
Close
ENG
INTL
5:40 pm
18/03/2023
