The first three photos are the data base. there are two tasks. First is 1-20. The second is 1-13. I will give a thumps up

Its an SQL task. The first three photos are the database as i said earlier.

The forth photo: SQL-task, part 1 (please answer the questiions 1-10)

The rest of the photos that is from the fifth to the end : Part 2(please answer the questions from 1-13)

let me know if you still need clarifications

Create sol query for every task and return them as a single sqi flle. 11. Feteh al1 columna of peraons whose salary is net 2800 12. Yetch al1 peraons from departhent 3 who are from Tanpere or whose tax percentage is 22 13. Fetch all whose degree ls MEe or. Yo and whose salary is 3100 or 2900 14. Fetch last name, eity and salary for all persons who have born after 1994 15. Fetch a11 peraons whose ofty starts with letter T 16. Fetch al1 projects that has atring P in its nanie 17. Fetch al1 peraons whose second letter is not e 18. Fetch al1 persona whose salary is between 20003000. Use Betweenoperator, 19. Fetch all persons whose aalary 182600 , 2800 or 3100 . Use isoperator, 20. Fetch all projects that have no location. 1. Feteh alphabecicaliy lant name of the last person fron Furku. Mesult must be like thist last Yirta 2. Hor many different degrees there are in person table? fet header as count, 3. What is the reasion for following querien to end up in different reaulta? neleet avg thocis is glanked from privl piersi 4. Fecch all the persons, forn a eingle string frcon first name and salary 14ke 'Jukka 2 . Bk'. That seans Jokkas salary in kiloeuros rounded to one decimal. Sort descending by, salary. Result shoutd be Hike thist salary2 Mako 3.1k Raili 3.1k fuika 3.0k Juldia 28 . IHke inj theret riman itatitio thetronidatel loan_dote: Ithurn_date Iutionery Thurydey 7. Counc the sum of salaries for each oity; (city, total talary) 8. Hoy many projects are on each location? retch location and eount with allas naned "tesal", 9. Coant persons' tares with Aalary and tax percontsee. Colunno are soesecne, Inone, faame, salary, taxpere and tax, fort by tax descending. 10. What is che ditference between miniaus and maxinun salaries and hev nock bidaer ia che eaxinun salary than tha atilmun salafy in percentage. 11, Tetch naned and sataries of those people whose salary woult be over 3000 afcer 100 increan in alary. 12. Tetch nanes, sataries and difference to maximun sajary in percentage- 13. Make a query that returns following data. Count the average houra done to each project per person and the average cost per person in eurosi The hourly cost is project id's number times ten. Wikh Pl it's 10/h. P2 20e/h and so on. Round the reaulta to integer. Create sol query for every task and return them as a single sqi flle. 11. Feteh al1 columna of peraons whose salary is net 2800 12. Yetch al1 peraons from departhent 3 who are from Tanpere or whose tax percentage is 22 13. Fetch all whose degree ls MEe or. Yo and whose salary is 3100 or 2900 14. Fetch last name, eity and salary for all persons who have born after 1994 15. Fetch a11 peraons whose ofty starts with letter T 16. Fetch al1 projects that has atring P in its nanie 17. Fetch al1 peraons whose second letter is not e 18. Fetch al1 persona whose salary is between 20003000. Use Betweenoperator, 19. Fetch all persons whose aalary 182600 , 2800 or 3100 . Use isoperator, 20. Fetch all projects that have no location. 1. Feteh alphabecicaliy lant name of the last person fron Furku. Mesult must be like thist last Yirta 2. Hor many different degrees there are in person table? fet header as count, 3. What is the reasion for following querien to end up in different reaulta? neleet avg thocis is glanked from privl piersi 4. Fecch all the persons, forn a eingle string frcon first name and salary 14ke 'Jukka 2 . Bk'. That seans Jokkas salary in kiloeuros rounded to one decimal. Sort descending by, salary. Result shoutd be Hike thist salary2 Mako 3.1k Raili 3.1k fuika 3.0k Juldia 28 . IHke inj theret riman itatitio thetronidatel loan_dote: Ithurn_date Iutionery Thurydey 7. Counc the sum of salaries for each oity; (city, total talary) 8. Hoy many projects are on each location? retch location and eount with allas naned "tesal", 9. Coant persons' tares with Aalary and tax percontsee. Colunno are soesecne, Inone, faame, salary, taxpere and tax, fort by tax descending. 10. What is che ditference between miniaus and maxinun salaries and hev nock bidaer ia che eaxinun salary than tha atilmun salafy in percentage. 11, Tetch naned and sataries of those people whose salary woult be over 3000 afcer 100 increan in alary. 12. Tetch nanes, sataries and difference to maximun sajary in percentage- 13. Make a query that returns following data. Count the average houra done to each project per person and the average cost per person in eurosi The hourly cost is project id's number times ten. Wikh Pl it's 10/h. P2 20e/h and so on. Round the reaulta to integer