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
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.
Được trao cho:
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.
32 freelancer đang chào giá trung bình $135 cho công việc này
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
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