sqlchecker.ru — сайт sqlchecker.ru

Технологии

• seo_signals: canonical, open_graph, robots_meta

О сайте

Title: SQL Checker — проверка SQL-заданий онлайн

Description: SQL Checker — платформа для обучения SQL: выполнение запросов, автоматическая проверка домашних заданий, прогресс и подсказки.

---

SELECT id, count() AS n FROM orders WHERE status = 'active'; INSERT INTO users (name, email) VALUES ('admin', 'a@b.c'); UPDATE products SET price = price 1.1 WHERE categoryid = 5; -- комментарий к запросу SELECT sum(amount), avg(amount) FROM orderdetails GROUP BY orderid; SELECT country, COUNT() AS cnt FROM orders GROUP BY country ORDER BY cnt DESC;

WITH cte AS (SELECT FROM t) SELECT FROM cte JOIN other ON cte.id = other.id; CREATE TABLE logs (id SERIAL, msg TEXT); jsonagg(data), arrayagg(id), rownumber() OVER (PARTITION BY x);

FROM orders JOIN customers ON orders.customerid = customers.id COALESCE(x, 0), NULLIF(y, '') WHERE createdat now() - '7 days'::interval

Логин или emailПарольВойти