Pergunta de entrevista da empresa Overdrive

You have two SQL tables: [Salesperson] spid | name --- 1 | Robin 2 | Patrick 3 | Julie 4 Kat [Sales] sid | spid | amount --- 1 | 1 | 5.00 2 | 2 | 5.00 3 | 1 | 5.00 4 | 4 | 5.00 5 | 4 | 5.00 6 | 1 | 5.00 Write a SQL query that returns all salespeople with their total sales