We will hire right candidate who pass the test for long term contract.
I have a sqlite db with two tables and write a single SQL query that looks at readings table and figures out the average based on the last 5 readings for that sensor ID, compares it to the minMoisture on the plants table and returns the valve IDs if it is less than that value.
You Should be able to:
1. Look at the moistures table and figure out the the average for each sensor ID based on the last
2. left join to the plants table and compare to the min moisture
3. then select where the average is less than the min moisture
Please attach the query on your bid and after checking it, i will hire right condidate for our database management right now.
34 profesionistë freelancer dërguan një ofertë mesatare prej $23/orë për këtë punë
Hi, I am a 12 years experienced SQL developer. I went through the problem statement. It would be helpful if you can provide table schema of both the tables. Regards, Dipendu
Hi how are you? My name is Boris Schalk. I have read the job description you posted. As I'm a developer with strong experience in this field, I'd like to join you. Hope to meet you as soon. Have a good day