Find Jobs
Hire Freelancers

Database Management (long-term but after testing)

$15-25 USD / hour

Closed
Posted over 5 years ago

$15-25 USD / hour

We will hire right candidate who pass the test for long term contract. The test: 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 five readings. 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.
Project ID: 17984312

About the project

28 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
28 freelancers are bidding on average $23 USD/hour for this job
User Avatar
Hello~!! I am Gang Lee and I read your post. But I have something to ask you. Your idea is amazing and it will change the world! I am a magic talented developer in your skill. If you wanna be the success, hire me I am looking forward to keeping touch with you Thanks
$22 USD in 40 days
4.9 (19 reviews)
6.1
6.1
User Avatar
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
$20 USD in 40 days
5.0 (22 reviews)
6.0
6.0
User Avatar
As we hold freelancer preferred badge we are most promising team for that we have team of 27 developer with avg exp of 4.5 year. Please come om Pm to discus more and start project soon. Talented team is here for your website. I have done same kind of function in past for the same reason we have great understanding of your requirements. We can start project asap. To get desired result we have team of 27 qualified software eng. Please come on PM to discus more and start right way Regards Dsv Infosolutions Pvt. Ltd.
$23 USD in 40 days
4.8 (7 reviews)
5.7
5.7
User Avatar
hi i am expertise in sql query scripting having experience in both sql server and mysql . please let me know ur requirement
$38 USD in 20 days
4.9 (17 reviews)
4.5
4.5
User Avatar
Greetings, I'm professional database expert with 10+ years experience. Currently I'm working as DBA and DB developer in one of the leader company. As you can see in my profile, I have deep experience of same jobs like database administration and development by remotely. I'm top expert. -- Best regards, Davit Dartsimelia Senior Database Administrator & Developer
$50 USD in 18 days
5.0 (3 reviews)
4.4
4.4
User Avatar
Hi, nice to meet you. I have read your description. I would like to have conversation with chat to get more about your project. Thanks.
$15 USD in 40 days
4.9 (10 reviews)
4.1
4.1
User Avatar
Hello, how are you/ I'm a database expert and I have full experience with sql, sqlite, postgres, mysql, Nosql... and I'm not clear about your proposal, Please let me clear about the structure of tables I like to send your write query Hope for your reply. Regards
$22 USD in 40 days
4.9 (3 reviews)
3.2
3.2
User Avatar
Dear Sir, I have 15 years experience of Database field and designed many desktop application under Oracle Database through SQL. I red your requirement you want to Generate SQL query between Two Table I generate a lot of sql query more than two tables. If you have any question before hire me. Please contact me on text message. After completion of work any modification I can do. Thank you for taking the time to read my proposal and I look forward to hopefully hearing for you. Best regards Yaseen
$44 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i can do every type of work in MS SQL like Triggers, Views, Function, Transactions, Index, Procedures and Normalization .
$16 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I checked your test problem with 2 tables on sqlite db and I see you need a database expert for long-term position. query; SELECT * FROM moistures WHERE average < ( SELECT MIN(moisture) FROM plants ) ORDER BY id DESC LIMIT 5; I have good experience in various databases including Mysql, Sqlite, MonogoDB, Redis, Firebase DB, etc. I am able to work full-time and even I can fit your timezone. Please ping me to discuss more. Thanks
$22 USD in 40 days
0.0 (1 review)
0.0
0.0
User Avatar
select avg(reading) from ( select * ,ROW_NUMBER() Over (partition by sensorid order by dateofreading ) row from tblMoisture ) a where row between 1 and 5 group by SensorID having avg(reading) <(select min(moisturelevel) ml from tblPlant)
$22 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm SQL and ETL developer and do have rich experiences in both T-SQL an PL/SQL in complex environments. Also, I am SSIS, ODI and Informatica developer and of course, I administer databases in order to achive best possible performance of ETL jobs and BI queries tuning indexes and statistics. Finaly my cyrrent efforts are to develop my skills in Big data using Cloudera and Pyton. If that fits in your project needs, I'll be glad to do test how work will go. P.S. I can work in US working time shift, but I reside in Europe.
$25 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I have a very long SQL experience in Oracle and later in SQLite. Your test answer is: select sensor_id from (select sensor_id,avg(sensor_value) avg_val from readings a where rowid in (select rowid from readings b where a.sensor_id=b.sensor_id order by sensor_read_time desc limit 5) group by sensor_id) a left join plants b on a.sensor_id=b.sensor_id where a.avg_val < b.min_moisture BR
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have been working in developing SQL Server Solutions from last 12+ year. I am sure I would be suitable candidate for the business requirement you have. So, let's discuss this. Thanks, Santosh
$15 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Database administrators, SQL exp as well as PL/SQL Oracle experience, Business and systems analysis.
$22 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am Database developer with vast exp. in Oracle and Mysql. But I can work on sqlite project. I have demo ready and share with you.
$24 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design. Here is few technologies I have mastered since last 9 years and can deliver the best solutions if you get me hired. 1) Sql Server 2005/2008/2012 2) MYSQL, MS Access 3) Oracle (PL/SQL) 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS
$22 USD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Oct 18, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.