Houzeo Interview Questions and Answers

Use a subquery to find the highest number that appears only once in a column

• Use a subquery to filter out numbers that appear more than once

• Order the results in descending order and select the top 1

Use SQL query with window functions like ROW_NUMBER() to select consecutive data from a column

• Use ROW_NUMBER() to assign a unique number to each row based on a specific order

• Use a self join or subquery to compare the row numbers of consecutive rows

• Filter the rows where the row numbers are consecutive to select the consecutive data

Live data is real-time data that is constantly updated, while extract data is a static subset of data.

• Live data is connected to a data source and updates in real-time as the source changes.

• Extract data is a static subset of data that is created by filtering and aggregating live data.

• Live data is useful for real-time analysis and monitoring, while extract data is useful for creating static reports and dashboards.

• Extract data can be refreshed on a schedule or manually, while li...read more

Blend combines data from different data sources while Join combines data from the same data source.

• Blend is used when data sources have different levels of detail.

• Join is used when data sources have the same level of detail.

• Blend creates a new virtual table while Join adds columns to an existing table.

• Example of Blend: Combining sales data from Excel and customer data from Salesforce.

• Example of Join: Combining sales data from two different sheets in Excel.

SQL joins are used to combine data from two or more tables based on a related column between them.

• INNER JOIN: returns only the matching rows from both tables

• LEFT JOIN: returns all rows from the left table and matching rows from the right table

• RIGHT JOIN: returns all rows from the right table and matching rows from the left table

• FULL OUTER JOIN: returns all rows from both tables, with NULL values for non-matching rows

• CROSS JOIN: returns the Cartesian product of both tables