In contrast to the complexity of the MR program
described below, the DBMSs need only two fairly simple queries to
complete the task. The first statement creates a temporary table and
uses it to store the output of the SELECT statement that performs
the join of UserVisits and Rankings and computes the aggregates.
Once this table is populated, it is then trivial to use a second query
to output the record with the largest totalRevenue field.