Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing

Authors: David Kroenke

11th Edition

0132302675, 9780132302678

More Books

Students also viewed these Databases questions

Question

List the five steps in the decision-making model.

Answered: 1 week ago