I am attaching a file that contains table structure and test data of about 5 rows.
CREATE TABLE `temp2` (
`Date` date NOT NULL,
`ShortName` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
`Number` int(6) NOT NULL,
`LongName` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`Open` double NOT NULL,
`High` double NOT NULL,
`Low` double NOT NULL,
`Close` double NOT NULL,
`Volume` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Although only 4 columns (Date, ShortName, Close, Volume) are relevant, yet I have sent complete structure of the table.
This table will contain about 600 rows per day and will have data of about 15 years.
Requiredment:
I want to find out that which 'ShortName' has continuously increased 'Close' price and also increased the volume for variable number of days that will be selected at the time of running query. For example 4 days. from todays date backward meaning thereby most recent days. if price has increased and volume has not increased or vice-versa within those days, that 'ShortName' should not be selected.
Please note that dates have breaks of holidays in between.
I would prefer single statement query to be run from phpmyadmin SQL platform.
Dear Sir,
I'm a senior in SQL and I can do anything in it.
I read your requirements and i can do it
I have many projects in php and SQL DB and I will do it in Short time and high quality code and i will explain any code you want.
call me i wait you.
Regards
Ibrahim
$25 USD in 1 giorno
5,0 (5 valutazioni)
2,5
2,5
4 freelance hanno fatto un'offerta media di $25 USD
Dear Employer,
I’ve carefully gone through your job posting on “phpmyadmin SQL platform (SQL Coding)”.
I am available to take this project now. I can start this project immediately and I will be do complete this within your deadline and in fine budget.
I believe we are best suited to provide you with the solution you're looking for that. With my combined 4+ years of experience developing these solutions, I am confident you will be most satisfied with the work we do.
Recently I have successfully completed many of PHP, Wordpress projects.
For more on my skill and successfully finished jobs,please have a look on my Profile, Portfolio.
I am very much interested in your project with all of your requirements.
Let's clarify the requirement in details also if you want us to share our previous work let us know.I have a few questions about your project, please send me message so that we can discuss more.
Thank you for your consideration,
Best Regards,
Yogesh
Hello Sir,
We are team of professional developers with having more than 7 year's experience in this field also I read your project description and We are interested in it but still we need some more information Can we discuss the project ?
Regards
Jawad