1-hour phone screen.

SQL questions were fair but hard. The database schema had 4 or 5 tables, but the questions related to only one table.

In 30 minutes, I was able to answer only 2 SQL questions instead of 3. In addition, answers with subqueries were not counted as correct solutions.

Python/Java coding examples are easily found on Glassdoor, but not SQL.

SQL:

1. Given the table products (product_id, brand_name, product_name, product_price), find brand_names with an average price greater than 3 and having more than 5 products.
2. Given the table sales (sale_id, promotion_id, sale_amount, other_columns), find the percentage of sales with promotions (where promotion_id is NULL) in comparison to all sales.

Coding (Java):

1. Find the average word length in a sentence.
2. IP address validation.
3. Friends problem: Given a list of lists representing friendships (e.g., [[A,B], [B,D],[E]]), solve a related problem.