SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE users ( country_name varchar(255), created_date datetime, year_of_birth datetime, device_name varchar(255) ); INSERT INTO users VALUES ('A', '2020-01-02', '1980-01-02', 'Samsung Galaxy 10E'); SELECT device_name, COUNT(*) cnt FROM users WHERE YEAR(created_date) = 2020 AND year_of_birth < DATE_SUB(CURDATE(), INTERVAL 25 YEAR) GROUP BY device_name;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear