Let's say you have two SQL tables: authors and books. The authors dataset has $1$M$+$ rows; here's the first six rows:

$\backslash$table$[[$Author$\_$name,Book$\_$name$],[$Author$\_1,$book$\_1],[$Author$\_2,$book$\_2],[$Author$\_3,$book$\_3],[$Author$\_4,$books$\_4],[$Author$\_5,$books$\_5],[$Author$\_6,$books$\_6],[,],[$Book$\_$name,sold copies$],[$Book$\_1,1000],[$Book$\_2,1500],[$Book$\_3,34000],[$Book$\_4,29000],[$Book$\_5,40000],[$Book$\_6,4400]]$

Create an SQL query that shows the Top $3$ authors who sold the most books in total.