Questions per Category

0

Please login or register to vote for this query.

(click on this box to dismiss)

Internet of Things

Q&A for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

declare @IoTCategories table ([Categories] varchar(50), [Number of questions] int);

INSERT INTO @IoTCategories select 'Smart Home', 
(select count(*) from posts 
where Tags like '%smart-home%' OR
Tags like '%smart-home%' OR
Tags like '%alexa%' OR
Tags like '%google-home%' OR
Tags like '%amazon-echo%' OR
Tags like '%samsung-smarththings%');

INSERT INTO @IoTCategories select 'Products',
(select count(*) from posts 
where Tags like '%google-home%' OR
Tags like '%amazon-echo%' OR
Tags like '%samsung-smarththings%');

INSERT INTO @IoTCategories select 'Security',
(select count(*) from posts 
where Tags like '%security%');

INSERT INTO @IoTCategories select 'Privacy',
(select count(*) from posts 
where Tags like '%privacy%');

INSERT INTO @IoTCategories select 'Network and Protocols',
(select count(*) from posts 
where Tags like '%networking%' OR
Tags like '%mqtt%' OR
Tags like '%communication%' OR
Tags like '%wifi%' OR
Tags like '%protocols%' OR
Tags like '%zigbee%' OR
Tags like '%bluetooth%' OR
Tags like '%wireless%');

INSERT INTO @IoTCategories select 'Programming and Controllers',
(select count(*) from posts 
where Tags like '%hardware%' OR
Tags like '%raspberry-pi%' OR
Tags like '%sensors%' OR
Tags like '%microcontrollers%' OR
Tags like '%mosquitto%' OR
Tags like '%esp8266%' OR
Tags like '%digital-cameras%');

INSERT INTO @IoTCategories select 'Other',
(select count(*) from posts 
where Tags like '%definitions%' OR
Tags like '%standards%' OR
Tags like '%power-consumption%');

Select * from @IoTCategories

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results