Hi I am new to learning SQL and am stuck on a particular question on how to extract information from 2 tables. Im learning via FInnish language so sometimes I think the lessons are often lost in translation. This is the connections and the tables we are working from
The question is basically, I need to take the htun enim snimi from the henkilo table and I also need to show how many projects each individual person has done and the total number of hours they have worked (tunnit = hours worked). I am having problems trying to get it to show how many projects and total hours have been worked by each individual.
Any help is greatly appreciated!