Please answer all the 10 select queries according to the given data. Thank You!!!

If you want you can skip 4 questions from the top, wo you can start with e.5. Thank you!

D7 e.1 What is the maximum percentage for Women? e 2 What is the maximum percentage for Men? e.3 Write a NESTED select statement that shows the country and the percentage of women with college education for ONLY the country with the maximum percentage. (In other words, you are now adding the country to the result of question e.1. e.4 Write a select statement that shows all the countries where the percentage of men is greater than the percentage of women. Show the country name, the percentage of women and the percentage of men. e. Write a select statement that shows in HOW MANY countries the percentage of women is greater than the percentage of men. e.6 Write a select statement that shows all countries sorted in descending order according to the percentage of women. In every row show all three columns e.7 Look at the result of e.6. There are cases where the two countries have the same percentages for women. In such a case we also want to sort it in descending order by percentages of men. Write a Select statement that will do this. Hint: Iceland and Luxembourg both have 53.4% for women, but Luxembourg has a higher percentage of men, so these two lines should appear in reverse order now. e.8 Now write a select statement that will order by men first, and by women second, both in DESCENDING order. But in your output the column for men should be the MIDDLE column, and the column for women should be the third column. e.9 Write a select statement that shows the country and only one more column, the AVERAGE of men and women in the country, again sorted in descending order. The second column should have the column name AVG. Hint: Use a column alias. e.10 I don't expect you to know how to do this. So go to the website Stackoverflow and find the answer that somebody gave there years ago. Write a select statement that displays exactly the fourth row of the table EDUCATION B 1 Country Women Men 2 Australia 51.6 42.5 3 Austria 33.4 34.2 4 Belgium 44.8 36.5 5 Canada 65.5 53.2 6 Chile 25.6 24.6 7 Colombia 26.1 21.4 8 Czech Rep 26.1 22.4 9 Denmark 45.9 34.9 10 Estonia 51.8 30.9 11 Finland 53.5 38.6 12 France 40.6 35.1 13 Germany 27.3 32.5 14 Greece 33.6 30.2 15 Hungary 30.3 21.6 16 Iceland 53.4 37.3 17 Ireland 51 43.5 18 Israel 55.4 45 19 Italy 22.4 16.8 20 Japan 53.9 51.5 21 Korea 47.6 52.3 22 Latvia 43.7 27.1 23 Lithuania 50.5 35.5 24 Luxembou 53.4 50 25 Mexico 17.7 18.9 26 Netherlan 40.8 40 27 New Zeala 41.8 36.1 28 Norway 49.5 39 29. Poland 37.7 26.2 educationfile cleaned