Nested hive query


#1

Need a simple query to retrieve the date and all the orders created on that date, on which the maximum orders were created.