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.
|ID||STring||unique ID of the family|
|Name||String||Name of the primary contact|
|Family_size||integer||size of family.|
|ID||STring||Unique ID of the country.|
|Name||string||Name of the country.|
|Min_size||integer||minimum size of group to get a discount.|