QUESTION

A travel and tour company has two tables relating to customers:Families and Countries. Each tour off ...

A travel and tour company has two tables relating to customers:Families and Countries. Each tour offers a discount if a minimumnumber of people book at the same time.

Write a query (sql oracle)to print the maximum number ofdiscounted tours any one family can choose from.

Families Table

Name Type Description
ID STring unique ID of the family
Name String Name of the primary contact
Family_size integer size of family.

Countries Table

Name Type Description
ID STring Unique ID of the country.
Name string Name of the country.
Min_size integer minimum size of group to get a discount.

Public Answer

2LTFVT The First Answerer