CREATE ____ Cars (ID INT, Brand TEXT); SELECT name, age ____ students; SELECT name, age ____ students; SELECT * FROM employees ____ salary > 2000; INSERT INTO orders (id, amount) ____ (101, 250); SELECT name, grade FROM students ____ grade >= 5; SELECT department, AVG(salary) FROM employees ____ department; INSERT ____ cars (brand, year) VALUES ('BMW', 2020); SELECT COUNT(*) ____ orders; ____ name, city FROM clients WHERE city = 'Varna'; INSERT ____ students (name, age) VALUES ('Ivan', 17); INSERT INTO customers ____ ('Maria', 'Sofia'); ____ FROM students WHERE age < 10; DELETE FROM products ____ price > 50; ____ TABLE Students (ID INT, Name TEXT, Grade INT);

Въведение в езика SQL 18

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?