Apache Hive

Description

Run six complex queries on the superstore data. You should have:

• at least two predicates in in the WHERE clause of all queries
• at least three queries should have a GROUP by clause
• at least two queries should have an ORDER BY clause
• at least one should have a UNION clause

Submit the queries and a screenshot of the partial result that contains the number of rows returned.