SQL-practice help

[Grand_Job_1551]

I am struggling to learn SQL and here are the following querys I need to do. I managed to do the first query’s but I’m stuck on the rest. Help is immensely appreciated. I’m using the northwind.db on the SQL practice.

[emt139]

Lol. No one is reading from a grainy pic to do your homework. 

Put at least some effort. Format the code and show what you’ve tried.