68 329
Assignments Done
Successfully Done
In November 2018

Answer to Question #61144 in Databases | SQL | Oracle | MS Access for Kate

Question #61144
I have a table:
_period(1,2,3,4,5,1,2,3,4,5,1,2; 1,2,3,4,5)
_reading2 (5,5,5,5,5,4,4,4,4,4,7,7;1,1,1,1,1)

i need a result like below which eliminates all data which doesn't have full period 1 to 5 for the _id, then calculates the sum of _reading for a day and sum of _reading2 for each distinct _id for a day:

sum_reading(5,10; 5)
sum_reading(15; 5)
Expert's answer
DELETE FROM "name_of_table" WHERE _id = 'x3';
SELECT _date, SUM(_reading) SELECT _date, SUM(_reading2)

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!


Assignment Expert
02.08.16, 18:57

Dear Kate,

please use panel to submit questions.

Assignment Expert
02.08.16, 16:30


02.08.16, 16:00


sum_reading(15; 5)

Leave a comment

Ask Your question

Privacy policy Terms and Conditions