Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using sql, can you please restructure the code to show the companies that did not decline Q8 No Single Day 12% Decline 10 Points Use
Using sql, can you please restructure the code to show the companies that did not decline Q8 No Single Day 12\% Decline 10 Points Use some or all of your query from Question 7 to list the companies that did not decline. S4. SELECT stock. Ticker, conpany.Conpany AS "Nane", stock.Date AS "First_Date", stock.Open, stock2.date AS "Last_Date", stock2. Close, concat(round (( stock2.Open - stock.Close) / stock.Open) "1e9), "k") As "Percentage Decline" FRON stock JOIN stock AS stock2 ON stock. Ticker - stock2. Ticker AND stock2.0ate = DATE_ADD ( stock.Date, INTERVAL 2 DAr) JoIN company ow stock. Ticker = company.Ticker WhERE stock2.close \&o e.88 * stock.Open onoent or "Percentage_Decilne
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started