Lab 1

Create in MS SQL Server the structure of a database containing the following information:

- information about political/military organizations (e.g. NATO)

• organization code
• organization name
• headquarter (city)
• founded date

- information about countries

• country name
• country code
• capital
• area
• population
• continent
• the organizations each country belongs to

1. List all the countries which are members of NATO.
2. List all the countries which are members of organizations founded before 1980
3. List all the countries which are members of only one organization
4. List all the capitals which are headquarter of no organization
5. List the population of each continent
6. Count the countries of each continent