#NoPayJan Offer - Access all CloudxLab Courses for free between 1st to 31st Jan
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