anhcuong

Day 1

• Read How to answer a coding interview.
• Read Using sliding window technique to solve coding interview questions.
• Practice coding Array 1 Two Sum
• Practice coding Array 2 Three Sum
• Practice coding Array 3 Max Consecutive Ones III
• Practice coding Array 4 Maximum Product Subarray

Day 2

• Read Using state machine to solve complex coding interview questions.

anhcuong

-- Bad use of aggregation
SELECT
  users.id,
  users.email,
  users.name,
  MAX(users.created_at) AS created_at, -- not necessary
  COUNT(orders.id) AS orders_count
FROM orders
LEFT JOIN users
       ON users.id = orders.user_id