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. |
Related Questions