/
romanchel1s
/
sql-translator
Обзор
Документация
Войти
/
romanchel1s
/
sql-translator
Код
Запросы
0
Задачи
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
backend/cases/case02.sql
29 строк
885 B
Roman Purtov
innit
01 сен 2024, 11:27
01 сен 2024, 11:27
58a1772
Код
Авторство
О чём код?
create table my_brick_collection ( colour varchar2(10), shape varchar2(10), weight integer ); create table your_brick_collection ( height integer, width integer, depth integer, colour varchar2(10), shape varchar2(10) ); insert into my_brick_collection values ( 'red', 'cube', 10 ); insert into my_brick_collection values ( 'blue', 'cuboid', 8 ); insert into my_brick_collection values ( 'green', 'pyramid', 20 ); insert into my_brick_collection values ( 'green', 'pyramid', 20 ); insert into my_brick_collection values ( null, 'cuboid', 20 ); insert into your_brick_collection values ( 2, 2, 2, 'red', 'cube' ); insert into your_brick_collection values ( 2, 2, 2, 'blue', 'cube' ); insert into your_brick_collection values ( 2, 2, 8, null, 'cuboid' ); commit; select colour, shape from your_brick_collection minus select colour, shape from my_brick_collection;