Registrations Closing Soon for DevOps Certification Training by CloudxLab | Registrations Closing in

  Enroll Now

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.


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: 

No hints are availble for this assesment

Answer is not availble for this assesment

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

Loading comments...