Question: Code the following queries in SQL: The following tables include information about tourists, their organizations, some organizations may have planned tours and information is kept
Code the following queries in SQL:

The following tables include information about tourists, their organizations, some organizations may have planned tours and information is kept about the tourists to participate in each tour; a tourist may work-for more than one organization. A tourist may participate in any tour whether organized by his/her organization or not. Each tourist has a city and a country where they live which may be different than their citizenship. Note that tid means tourist ID, code means tour code, org_name means organization name, sin_fd1 and sin_fd2 represent sin numbers of a person and his/her friend, citizenship is a country Tour(code, city, country, time, day) Participate(tid, code, class) Works-for(tid.org-name) Tourist(tid, sin, name, citizenship, city, country, age, gender) Organization(name, code, leader-tid, leader-sin, city, year_started) Friend(sin_fdl, sin_fd2) Code the following queries in SQL: a) Find id's and classes of tourists who participated only in tour(s) in Italy? b) Find tours which have the smallest number of Mexican participants? (notice that Mexico is a citizenship) c) Find the name of each organization whose leader is a tourist who does not lives in the same city where the organization is located
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
