Registrations Closing Soon for DevOps Certification Training by CloudxLab | Registrations Closing in
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:
Want to create exercises like this yourself? Click here.
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