United Coffee House Interview Questions and Answers

List is an ordered collection of elements while dictionary is an unordered collection of key-value pairs.

• Lists are accessed by index while dictionaries are accessed by keys.

• Lists can contain duplicate values while dictionaries cannot have duplicate keys.

• Lists are enclosed in square brackets [] while dictionaries are enclosed in curly braces {}.

• Example: list = [1, 2, 3] and dictionary = {'a': 1, 'b': 2, 'c': 3}

Window functions in SQL are used to perform calculations across a set of rows that are related to the current row.

• Window functions are used to calculate values based on a subset of rows within a larger result set.

• They allow you to perform calculations across rows that are related to the current row.

• Examples of window functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.

• Window functions are often used in conjunctio...read more

Fairmont has over 70 hotels worldwide.

• Fairmont has hotels in North America, Europe, Asia, Africa, and the Middle East.

• Some notable Fairmont hotels include The Plaza in New York City, The Savoy in London, and The Fairmont Banff Springs in Canada.

• Fairmont also has several resort properties, such as the Fairmont Mayakoba in Mexico and the Fairmont Southampton in Bermuda.

A Sazerac is a classic cocktail made with rye whiskey, absinthe, Peychaud's bitters, sugar, and a lemon twist.

• Start by chilling an old-fashioned glass with ice and set it aside.

• In a separate glass, muddle a sugar cube with a few dashes of Peychaud's bitters.

• Add rye whiskey and ice to the sugar mixture, then stir well.

• Discard the ice from the chilled glass and rinse it with absinthe, then strain the whiskey mixture into...read more