In today's Facebook-driven world, it's pretty easy to track old school friends. It's even simpler when you and your pals have consecutive names. In this case, everyone's last name happens to start with 'S'!
This is the story of a group of friends from the 1979 class of the University of San Francisco (USF) who decided to go on a reunion ski trip to Austria. However, some of them moved away from SF and now live in a region of Tirol. Obviously, those guys don't want to stay in their hometowns for a holiday.
Open the panel on the right side of the screen to check out the structure of the database for this Challenge. The database stores info about all tirolean POIs.
Find the first and last names of USF graduates along with their cities – but only if there's a way to book an accommodation for a winter holiday in that city. Remember to look for people whose last names start with the letter 'S'.
You'll need to use the person and accommodation tables.
