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

인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

자동 저장된 게임을 복구할까요?