Skip to main content
. 2016 Jun 27;16(7):980. doi: 10.3390/s16070980

Table 2.

Query execution scenarios.

Scenario Query
A SELECT count(userid)
FROM userrecognizedactivity
WHERE userid = 39;
B SELECT count(userid)
FROM userrecognizedactivity;
C SELECT count(userid)
FROM detected location
WHERE StartTime
BETWEEN ’1/29/2014’ AND ’12/10/2014’;
D SELECT count(userid)
FROM detected location
WHERE LocationLabel = ’Home’;
E SELECT count(userid)
FROM tblUserRecognizedHLC
WHERE StartTime
BETWEEN ’5/10/2015,2:45:01 AM’ AND ’12/9/2015,11:58:31 PM’;
F SELECT count(RecommendationID)
FROM tfblrecommendation
WHERE RecommendationDate
BETWEEN ’5/18/2015,10:01:59 AM’ AND ’12/15/2015,2:32:09 PM’;
G SELECT count(RecommendationFeedbackID)
FROM ShetblRecommendationFeedbacket3
WHERE FeedbackDate
BETWEEN ’5/18/2015,10:01:59 AM’ AND ’7/29/2015,3:20:28 PM’;
H SELECT count(UserRecognizedEmotionID)
FROM tblUserRecognizedEmotion
WHERE StartTime
BETWEEN ’5/10/2015,2:30:01 AM’ AND ’12/14/2015,2:00:00 PM’;