Expedia Group interview question

Why hotels.com? How to make SQL queries more efficient?