From the given data, write a MySql query to join two tables and arrange results in descending order. Another question I remember in R was from the Iris data set where in I was supposed to write a function to aggregate the sum of a variable by different species.