מעצב SQL

SELECT id, name, email FROM users WHERE active = 1 AND created_at > '2023-01-01'...

SELECT u.name, p.title, c.name as category FROM users u INNER JOIN posts p ON u....

SELECT * FROM products WHERE price > (SELECT AVG(price) FROM products WHERE cate...

INSERT INTO users (name, email, password, created_at) VALUES ('John Doe', 'john@...

UPDATE orders o JOIN customers c ON o.customer_id = c.id SET o.status = 'shipped...

WITH monthly_sales AS (SELECT DATE_FORMAT(created_at, '%Y-%m') as month, SUM(tot...