Find Jobs
Hire Freelancers

phpmyadmin SQL platform (SQL Coding)

$10-30 USD

In corso
Pubblicato circa 5 anni fa

$10-30 USD

Pagato al completamento
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.
Rif. progetto: 18452926

Info sul progetto

4 proposte
Progetto a distanza
Attivo 5 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
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
Avatar dell'utente
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
$25 USD in 0 giorno
5,0 (14 valutazioni)
3,9
3,9
Avatar dell'utente
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
$25 USD in 1 giorno
4,4 (8 valutazioni)
4,2
4,2
Avatar dell'utente
Hi, I'm fairly good at SQL queries and can help out with this problem. I'll make sure that it's optimal and efficient as it can be. Thanks.
$25 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: UNITED ARAB EMIRATES
Dubai, United Arab Emirates
0,0
0
Metodo di pagamento verificato
Membro dal gen 2, 2019

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.