SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE StockPropertyTemplate ( id int, group_id int, property_id int, type enum('property', 'variant') ); INSERT INTO StockPropertyTemplate VALUES (1, 9, 13, 'property'), (2, 9, 14, 'property'), (3, 9, 15, 'property'), (4, 9, 14, 'variant'), (5, 8, 14, 'property'), (6, 8, 15, 'variant'), (7, 8, 13, 'property'); SELECT group_id, COUNT(NULLIF(type, 'variant')) as count_property, COUNT(NULLIF(type, 'property')) as count_variant FROM StockPropertyTemplate GROUP BY group_id;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear