0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT CAST('64bit'AS VARCHAR(50)), COUNT(1) FROM BADGES WHERE BADGES.NAME = '64bit' UNION ALL
SELECT CAST('adfs2.0'AS VARCHAR(50)), COUNT(1) FROM BADGES WHERE BADGES.NAME = 'adfs2.0' UNION ALL
SELECT CAST('alamofire'AS VARCHAR(50)), COUNT(1) FROM BADGES WHERE BADGES.NAME = 'alamofire' UNION ALL
SELECT CAST('alfresco-share'AS VARCHAR(50)), COUNT(1) FROM BADGES WHERE BADGES.NAME = 'alfresco-share' UNION ALL
SELECT CAST('algolia'AS VARCHAR(50)), COUNT(1) FROM BADGES WHERE BADGES.NAME = 'algolia' UNION ALL
SELECT CAST('alsa'AS VARCHAR(50)), COUNT(1) FROM BADGES WHERE BADGES.NAME = 'alsa' UNION ALL
SELECT CAST('amazon-mws'AS VARCHAR(50)), COUNT(1) FROM BADGES WHERE BADGES.NAME = 'amazon-mws' UNION ALL
SELECT CAST('android'AS VARCHAR(50)), COUNT(1) FROM BADGES WHERE BADGES.NAME = 'android' UNION ALL
SELECT CAST('android-4.4-kitkat'AS VARCHAR(50)), COUNT(1) FROM BADGES WHERE BADGES.NAME = 'android-4.4-kitkat' UNION ALL
SELECT CAST('android-adapter'AS VARCHAR(50)), COUNT(1) FROM BADGES WHERE BADGES.NAME = 'android-adapter' UNION ALL
SELECT CAST('android-canvas'AS VARCHAR(50)), COUNT(1) FROM BADGES WHERE BADGES.NAME = 'android-canvas' UNION ALL
SELECT CAST('android-fragmentactivity'AS VARCHAR(50)), COUNT(1) FROM BADGES WHERE BADGES.NAME = 'android-fragmentactivity' UNION ALL
SELECT CAST('android-intent'AS VARCHAR(50)), COUNT(1) FROM BADGES WHERE BADGES.NAME = 'android-intent' UNION ALL
SELECT CAST('android-listfragment'AS VARCHAR(50)), COUNT(1) FROM BADGES WHERE BADGES.NAME = 'android-listfragment' --UNION ALL

fork query

edited sep 2 16

created aug 13 16 anonymous