CCA159 : Task Scenario-17
Problem Scenario 17: As you have been given below table.
HADOOPEXAM_STOCK (exchange string, stock_symbol string, closing_date timestamp, closing_price decimal(8,2))
1. Write a query , which generate report as below.
exchange, stock_symbol , closing_date , closing_price , yesterday_closing , diff_yesterday_price (Price difference between Yesterdays price and todays price)
2. Write a query , which generate report as below.
exchange, stock_symbol , closing_date , closing_price , yesterday_closing , diff_last7days_price (Price difference between last 7days price and todays price)
3. Write a query which will print, whether following day price is higher , lower . Output should be like this.
exchange,stock_symbol, closing_date, closing_price, position
Content
Certification Content
Professional HandsOn Trainings
(Lifetime Access and Free upgrades)
ApacheSpark Interview Questions
· Apache Spark InterviewQuestions-1
· Apache Spark Interview Questions-2
· Apache Spark Interview Questions-3
· Apache Spark Interview Questions-4
· Apache Spark Interview Questions-5
· Apache Spark Interview Questions-6
Apache Spark Interview Questions-7
Java MultiThreading Interview Questions
· Java Multi-Threading Intrview Questions-1
· Java Multi-Threading Interview Questions-2
· Java Multi-Threading Interview Questions-3
· Java Multi-Threading Interview Questions-4