SELECT distinct portname FROM excursions;
SELECT distinct region FROM ports;
SELECT region, sum(excursioncount) FROM ports
group by region asc;
SELECT portname,excursioncount
FROM ports
WHERE region = 'Africa'
ORDER BY portname asc
SELECT portname,excursioncount
FROM ports
WHERE region = 'Alaska'
ORDER BY portname asc
SELECT portname,excursioncount
FROM ports
WHERE region = 'Asia'
ORDER BY portname asc
SELECT portname,excursioncount
FROM ports
WHERE region = 'Australia'
ORDER BY portname asc
SELECT portname,excursioncount
FROM ports
WHERE region = 'Canada'
ORDER BY portname asc
SELECT portname,excursioncount
FROM ports
WHERE region = 'Caribbean'
ORDER BY portname asc
SELECT portname,excursioncount
FROM ports
WHERE region = 'Continental United States'
ORDER BY portname asc
SELECT portname,excursioncount
FROM ports
WHERE region = 'Europe'
ORDER BY portname asc
SELECT portname,excursioncount
FROM ports
WHERE region = 'Hawaii'
ORDER BY portname asc
SELECT portname,excursioncount
FROM ports
WHERE region = 'Mexico'
ORDER BY portname asc
SELECT portname,excursioncount
FROM ports
WHERE region = 'New Zealand'
ORDER BY portname asc
SELECT portname,excursioncount
FROM ports
WHERE region = 'South America'
ORDER BY portname asc
Shore Excursion Review
To view the excursions available by port, click on the region and then a port from the list of ports within the region. The number next to each port name indicates the number of excursions listed for that port.