Lab Quiz (5%)

Salam..


Answer the following question based on the tables above.

1. Insert data for Person table ('6', 'Siti', 'Bestari Jaya', '22').

2. List all value from Company table. (YearofWork is greater than 7).

3. List column Name, Address from Person table . (Age is less or equal with 30).

4. Update from Company table where the Position is equal with 'Accountant' and set the Workplace as '456 Co.'.

5. Sort in ascending the Person table accordingly with the age.

Good Luck ;)