Terminé

urgent: mysql expert needed to build qury to get running hours

hello,

i have a table name: maa_gen_fix

the table has data for Power Generators running hours.

every generator whois running hours reach 500 hours needs maintenance.

maintenance is done when genrator run for 500 hours.

the hours are being taken monthly or 2-3 time per month, so you will find many generators with multiple rows per month.

the table is with these fields:

gen_id = generator id

fix_date = the date when the running hours taken.

current_hours = current ruining hours

i want you to do this:

build smart (query or Procedure or function) to predict /forecast/guess the >=500 hours

for example

month 7 Jul : 8000 hours

month 8 Aug: 8300 hours

8300-8000 = 300 hours

on 2019-10-21 today, when i run query i must see all gen_id whos running hours >= 500

you have to depend on CURRENT DATE, and read generator history to guess the hours

the table schema is attached to this project.

regards

Compétences : MySQL, PHP, Architecture Logicielle, Programmation de bases de données

en voir plus : php expert needed, joomla expert needed, web security expert needed, photoshop expert needed san jose, volusion expert needed, digg expert needed, linux expert needed, urgent captcha team needed creationtc, mod rewrite expert needed, zen cart expert needed, php web scraping expert needed, j2me expert needed, net graphics expert needed, hours needed build small simple website, mysql expert needed, php expert needed build job posting website, php ajax mysql google maps expert needed, urgent mysql start fix quick fix needed, vba expert needed - urgent

Concernant l'employeur :
( 6 commentaires ) diralabalah, Palestinian Territory

Nº du projet : #21901707

Décerné à:

kozachenkodr

Hello. I am so familiar with Mysql, have done many jobs related wtih sql. Please ping me to discuss more, I am sure I will provide the best result for you. I am ready to start right now. Regards.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 7 jours
(9 Commentaires)
4.0

32 freelance font une offre moyenne de $135 pour ce travail

usuf001

Hi there, I can write MySQL stored procedure to return all gen_id running > 500 hours. thank you so much syed

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(571 Commentaires)
7.3
ShiaFirst

Hi, it’s pretty simple for me, but i have few questions to ask, knock me for further discussion, Thank you

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(125 Commentaires)
7.0
coco007

Hi. I am very interested in your job. I have just downloaded the attached .sql dump file and estimate it will take 1 day to build these queries. Please feel free to contact me if you are interested in my bid. Regard Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(5 Commentaires)
6.4
reservestep

"I am expert PHP developer and i will build query for running hours according to project description" Hello there, my name is Anusuya and i’m a full-time, reliable, and highly experienced Freelancer with expertise in Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(102 Commentaires)
6.4
jamesmartin81

I have experience of Website in PHP, Laravel, CodeIgnitor, Wordpress, Opencart, Woocommerce, Photoshop, Adobe Illustrator . We also have experience of making Android,Window and iphone application with ionic & phonegap. Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(134 Commentaires)
6.1
Jinzin

Hello, How are you? I have already read your description and have checked your SQL file carefully. I can do your project perfectly with my rich experience of 7+ years about MYSQL. I'm a professional web developer who c Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(46 Commentaires)
5.8
aykutcanturkmen

Hi, client.I have read your project details and this is a task designed according to my skills. As you can see my review I'm a full stack web developer who has combined frontend and backend. My backend skills: node.js, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(49 Commentaires)
5.8
bormaa

Dear sir, i can do your job and find it satsify my skills and will provide you with fast process and high quality code that you need

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(43 Commentaires)
5.2
romancoder204

Hello, hope you are doing well. When I read this job project details very carefully, and feeling my skills are very good fit for this project. As an expert in SQL and sql query, I am very confident in this project. Pl Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(22 Commentaires)
5.3
malikbilal15

Hi I can build this query right now thanks billal

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(53 Commentaires)
5.2
dhavalschotaliya

Hello there? I have read your requirement and I am interested in your job. I can start work right now. I will create sql query for get hours. Waiting for your reply Thank you

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(57 Commentaires)
5.1
seniorcoder024

Hello, sir. I would be very glad to meet you. I read your description carefully. I can bring you perfect result as you want. I am an experienced web developer and designer with the depth knowledge related to PHP, Boots Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(16 Commentaires)
4.6
greenguru2018

Hello, How are you? My pleasure to bid your project. I've read carefully your project description. I have more than five years experience in development related with your project. Your satisfaction with the project is Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(17 Commentaires)
4.4
zeeshan411

Hi, I have read your project description. I am full stack developer having 10 years working experience and I am very confident to build your website in PHP, WordPress, Laravel, Codignator and Reactjs. I am an exp Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(21 Commentaires)
4.3
jinridong19713

Only 1 day, I can finish it for you. Hi thanks for your posting. I have read your post. I am a expert who have many experiences in web design&development. In particular, I had great experiences in sql and database mana Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(10 Commentaires)
4.5
lesteraguilar

Fingers crossed for your job.. I am sure of Angular.js, React.js, Vue.js, PHP, Laravel, CI, node.js, Python, Django, MySQL, MongoDB, PostgreSQL, Google Firebase, Docker, Javascript, Java, CSS, Bootstrap, HTML. Kindly d Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(13 Commentaires)
4.0
WongGanteng

I'm very happy to bid on your project. I read your description carefully and am very interesting in your project. I can start right now and I can confirm high quality. If you hire me,I will do my best for your job and Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(5 Commentaires)
4.2
WebExpertNatasha

Dear,Client. I have read your description very carefully and I can understand what you want. I am an SQL expert. I can solve your problem. I am checking your table scheme. I really want to discuss with you for more inf Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(13 Commentaires)
4.0
limitbreak515

? The Client is Always Right! ? Hello. Sir. Glad to meet you I checked your project description carefully. I am a senior MySQL developer and have enough experience, so I am very confident to do this project. :) I'm n Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(4 Commentaires)
4.0
AlexeySamara88

Hi, Can we discuss your task details more? I'm available to start immediately. Let me know if you'd like to set aside some time to chat. Best Regards, Alexey

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(4 Commentaires)
3.2