I have two tables, I want to grab the total number of skills required for a specific job position and update this table's column with that information.

The tskill column is the one intended for the information to be updated to.

```
pnum  sname  
===============
001   cooking        
001   cleaning
002   teaching
003   driving

pnum   ptitle  tskill          
===================
001   chef  
002   teacher
003   driving instructor

```

Sample data with relevant columns (tskill is a new added column in POSITIONS which is currently all empty)

```
INSERT INTO POSITIONS VALUES ( 001, 'chef')
INSERT INTO POSITIONS VALUES ( 002, 'teacher')
INSERT INTO POSITIONS VALUES ( 003, 'driving instructor')

INSERT INTO SNEEDED VALUES ( 001, 'cooking');
INSERT INTO SNEEDED VALUES ( 001, 'cleaning');
INSERT INTO SNEEDED VALUES ( 002, 'teaching');
INSERT INTO SNEEDED VALUES ( 003, 'driving');

```

Any tips for doing this with the update statement?