CODE IN SQL

The following tables include information about volunteers, their organizations, their planned projects, and volunteers who

will participate in each project; a volunteer may be member in more than one organization. Friend is a table which includes

in each row sin numbers of two friends who may or may not be volunteers

Note that vid is volunteer ID$,$ code is project code, org$\_$name is organization name, sin$\_$fd$1$ and sin$\_$fd$2$ represent sin

numbers of two friends, citizenship is a country

Project$($code$,$ city, country, time, day$)$ Participate$($vid$,$ code, role$)$

Member$($vid$,$org$-$name$)$ Volunteer$($vid$,$ sin$,$ name, city, citizenship, age, gender$)$

Friend$($sin$\_$fd$1,$ sin$\_$fd$2)$ Organization$($name$,$ leader$-$vid, leader$-$sin$,$ city, year$\_$started$)$

$1.$ Find vid$$s and roles of volunteers who participated in at least one project in Uganda? $($Uganda is a country$)2.$ For cities where there are projects but no volunteers?$3.$ For cities which have at least one organization and at least one volunteer, find number of organizations$$and number of volunteers in each such city?$4.$ Find the name of each organization whose leader have only friends who volunteered?$5.$ Find name of every female volunteer who only participated in all projects in her city?$6.$ Find codes of projects which are located inside countries from which there is at least one male volunteer$$over $50$ years old?