Lukket

Database Management (long-term but after testing)

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.

Evner: Database Administration, Programmering af database, SQL, SQLite

Se mere: database testing tutorial, database testing tools, database testing checklist, database testing test cases, how to do database testing manually, database testing guru99, database locking tutorial, types of database testing, database administration, database development, database programming

Om arbejdsgiveren:
( 0 bedømmelser ) United States

Projekt ID: #17984312

35 freelancere byder i gennemsnit $22/time for dette job

truongnguyen86

Hello there, this is the query of mine: select * from (select SensorID,avg(reading) avg_read from moistures m1 where concat(SensorID,'-',reading) in (select concat(SensorID,'-',reading) Flere

$25 USD / time
(149 bedømmelser)
6.5
Yknox

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 Flere

$22 USD / time
(17 bedømmelser)
5.8
langlangFan

Hi, thanks for your job posting. I don't look new client but I read your serious job posting. I am good at website design and development. Frankly to say, I have 10+ years of software experience. The most important Flere

$22 USD / time
(3 bedømmelser)
5.2
latatestTech

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 you Flere

$23 USD / time
(4 bedømmelser)
5.0
admin845

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 / time
(21 bedømmelser)
5.1
SergioAlfaroV

Hello! I am a Computer Engineer, with a Master of Business Administration and a MCSA SQL Server 2014, with 12 years of experience using SQL, queries, reports and dashboards design and construction, database management, Flere

$25 USD / time
(12 bedømmelser)
4.8
ashupathania

I have experience in SQL,SSIS,SSRS

$16 USD / time
(26 bedømmelser)
4.8
dat2na

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 lik Flere

$50 USD / time
(2 bedømmelser)
4.2
sreenivas2903

hi i am expertise in sql query scripting having experience in both sql server and mysql . please let me know ur requirement

$38 USD / time
(9 bedømmelser)
3.9
xinglong717

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 / time
(2 bedømmelser)
3.1
peng72083

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 s Flere

$22 USD / time
(1 bedømmelse)
2.4
BissiEU

Hi Dave, very interesting challenge ! 1st: we have 2 tables, but during the explanation we found "readings table" "plants table" "moistures table" My answer suppose that readings/moistures is the same "moistur Flere

$15 USD / time
(1 bedømmelse)
1.2
hammadabbasi01

Hi, Review my profile  5 Years of experience as BI/ETL Developer and Oracle Business Intelligence Certified professional. Adept in preparing data for analysis, Creating dashboards deploying dashboards on server Flere

$15 USD / time
(2 bedømmelser)
1.2
BorisSchalk

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

$22 USD / time
(1 bedømmelse)
0.6
attamustafa511

i can do every type of work in MS SQL like Triggers, Views, Function, Transactions, Index, Procedures and Normalization .

$16 USD / time
(0 bedømmelser)
0.0
sunilmudunuri

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 doin Flere

$22 USD / time
(0 bedømmelser)
0.0
Jingchen15

select * from ( select [login to view URL] ,avg([login to view URL]) as avgMoisture from moistures a where exists (select count(*) from moistures b where a.sensorID=[login to view URL] and [login to view URL]> [login to view URL] group by sensorI Flere

$22 USD / time
(0 bedømmelser)
0.0
adhikarimadhu

Hi, This is Madhusudan Adhikari, located in Kathmandu,Nepal. I have 15+ years experience in database design, development,DBA activities including expertize in ETL/Business intelligence tasks,using Oracle and SQL Ser Flere

$16 USD / time
(0 bedømmelser)
0.0
BrunoFMAlmeida

SELECT [login to view URL], [login to view URL] FROM (SELECT SENSORID, AVG(READINGVALUE) AS VAL FROM MOISTURES WHERE ROWID IN ( SELECT ROWID FROM MOISTURES ORDER BY ID DESC LIMIT 5) GROUP BY ID ) Flere

$27 USD / time
(0 bedømmelser)
0.0
vw6326514vw

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 / time
(0 bedømmelser)
0.0