I have a database that contains information about object vibrations. Each object vibrates a certain number of times per minute. I’m trying to write a query that displays the data about each object. The query must display the date, time and vibrations per minute for each object.
Object 1 vibrated 5 times in 1 second. Object 2 vibrated one time 2 seconds. Object 3 vibrated 9 times in 3 seconds.
I had to change the extension of the backup file to .txt in order to upload it to EE. Just change the extension back to .bu.
Please help me write a query that displays the date, time and vibrations per minute for each object.
, convert(time,a.tTime) Time
, Object1 = MAX(ISNULL( b.Object_1 * c.Duration / 60.0, 0 ))
, Object2 = MAX(ISNULL( b.Object_2 * c.Duration / 60.0, 0 ))
, Object3 = MAX(ISNULL( b.Object_3 * c.Duration / 60.0, 0 ))
FROM tblTimes a
JOIN tblObjects b ON a.TimeID = b.TimeID
JOIN tblDurations c ON b.DurationID = c.DurationID
GROUP BY a.tDate,convert(time,a.tTime)