SELECT( (SELECT COUNT(*) FROM ( SELECT Id FROM Posts WHERE Id in (SELECTTagsTest1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Skeptics

Q&A for scientific skepticism

SELECT(

  (SELECT COUNT(*) FROM (

      SELECT Id FROM Posts WHERE Id in 
        (SELECT PostId FROM PostTags WHERE TagId in (
          (SELECT Id FROM Tags WHERE TagName like '%ios%')))
      INTERSECT
      (
        SELECT Id FROM Posts WHERE Id in
          (SELECT PostId FROM PostTags WHERE TagId in (
            (SELECT Id FROM Tags WHERE TagName like '%swift%')))
        UNION
        SELECT Id FROM Posts WHERE Id in
          (SELECT PostId FROM PostTags WHERE TagId in (
            (SELECT Id FROM Tags WHERE TagName like '%objective-c%')))
      )

      ) as numberOfNativeiOSQuestions
    )
    +
    (SELECT COUNT(*) FROM (

      SELECT Id FROM Posts WHERE Id in 
        (SELECT PostId FROM PostTags WHERE TagId in (
          (SELECT Id FROM Tags WHERE TagName like '%android%')))
      INTERSECT
      (
        SELECT Id FROM Posts WHERE Id in
          (SELECT PostId FROM PostTags WHERE TagId in (
            (SELECT Id FROM Tags WHERE TagName like '%java%')))
        UNION
        SELECT Id FROM Posts WHERE Id in
          (SELECT PostId FROM PostTags WHERE TagId in (
            (SELECT Id FROM Tags WHERE TagName like '%kotlin%')))
      )

      ) as numberOfNativeAndroidQuestions
    )
  )

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results