การทดสอบ Android ใหม่ตามปี ไม่จำเป็นต้องใช้ตารางทั้งหมด
New Android Testing by Year.It is not neccessary to use all the tables.
 Comments:  Id [ number]  PostId [ number]  Score [ number]  Text [ text]  CreationDate [ time]  UserDisplayName [ text]  UserId [ number]  ContentLicense [ text] 
SELECT COUNT(P.Title), YEAR(P.CreationDate) FROM Posts AS P WHERE (P.Tags LIKE '%android-testing%') OR (P.Tags LIKE '%robotium%') OR (P.Tags LIKE '%androidviewclient%') OR (P.Tags LIKE '%monkeyrunner%') OR (P.Tags LIKE '%robolectric%') OR (P.Tags LIKE '%android-espresso%') OR (P.Tags LIKE '%android%' AND P.Tags LIKE '%uiautomator%') OR (P.Tags LIKE '%android%' AND P.Tags LIKE '%appium%') OR (P.Tags LIKE '%android%' AND P.Tags LIKE '%calabash%') OR (P.Tags LIKE '%android%' AND P.Tags LIKE '%test%') GROUP BY YEAR(P.CreationDate)