Project - Hive - NYSE

3 / 3

Hive Project - Step 3 - Write Queries

Now, as you have successfully loaded the data into the table. Please complete the below queries based on the table data.

INSTRUCTIONS

Fill in the blanks to complete the following queries. Please input text in lowercase.

Q1: This query should give unique symbols

select  symbol  nyse

Q2: This query should give out two columns: symbol and average open price for each symbol.

select , (price_open) AS avg_price  nyse  symbol;

Answer some more questions related to the data:

Q3: The symbol for which the price_open was maximum:  and the maximum was on this date in the yyyy-mm-dd format: 
See Answer

No hints are availble for this assesment


Note - Having trouble with the assessment engine? Follow the steps listed here

Loading comments...