Tables are : COUNTRY (CODE, NAME) and MEMBER (ORGANIZATION, COUNTRY_code). primary keys are in blod letters and foreign key is in italics.
SELECT
COUNTRY.name
FROM
COUNTRY
JOIN member
ON
COUNTRY.code= member.
COUNTRY_code
WHERE member.
ORGANIZATION =ALL(SELECT organization
FROM member
WHERE
member.
COUNTRY_code=
COUNTRY.code )
What wil be the output of given SQL query?
1. List the names of countries which are members of at least one organisation.
2. List the names of countries which are members of only one organisation.
3. List the names of countries which are members of one or more organisations.
4. List the names of countries which are members of all organisations.