■Sample301
SELECT * FROM resource;

■Sample302
SELECT
  code AS '商品コード',
  name AS '商品名',
  class AS '分類',
  price AS '価格'
FROM resource;

■Sample303
SELECT 1 + 2;

■Sample304
SELECT 5 + 2, 5 - 2, 5 * 2, 5 DIV 2, 5 % 2, 5 / 2;

■Sample305
SELECT 1 + 2 * 3, (1 + 2) * 3;

■Sample306
SELECT code, name, class, price, price * 1.1 FROM resource;

■Sample307
SELECT
  code AS '商品コード',
  name AS '商品名',
  class AS '分類',
  price AS '価格',
  price * 1.1 AS '税込み価格'
FROM resource;

■Sample308
SELECT ABS(-10), ABS(10);

■Sample309
SELECT ROUND(150.0), ROUND(150.0, 1), ROUND(150.0, 2);

■Sample310
SELECT name, price FROM resource WHERE class = 'text';

■Sample311
SELECT name, price FROM resource WHERE price >= 3000 AND price < 5400;

■Sample312
SELECT * FROM resource WHERE class = 'text' OR class = 'pbbk';

■Sample313
SELECT name, price FROM resource WHERE price BETWEEN 2000 AND 5400;

■Sample314
SELECT name, price FROM resource WHERE price >= 2000 AND price <= 5400;

■Sample315
SELECT * FROM resource WHERE class IN ('sftw', 'pbbk');

■Sample316
SELECT * FROM resource WHERE code LIKE '1001%';

■Sample317
SELECT name, price FROM resource WHERE price NOT BETWEEN 2000 AND 5400;

■Sample318
SELECT name, price FROM resource WHERE price < 2000 OR price > 5400;

■Sample319
SELECT * FROM resource WHERE class NOT IN ('sftw', 'pbbk');

■Sample320
SELECT * FROM resource WHERE class <> 'sftw' AND class <> 'pbbk';

■Sample321
SELECT * FROM resource WHERE code NOT LIKE '1001%';



■例題3-1
SELECT
  id AS '学生番号',
  grade AS '学年',
  name AS '名前'
FROM student;


■例題3-2
SELECT
  code AS '商品コード',
  name AS '商品名',
  class AS '分類',
  price AS '価格',
  price * 0.1 AS '税金',
  price * 1.1 AS '税込み価格'
FROM resource;


■例題3-3
（1）
SELECT id, name FROM student WHERE grade = 3;

（2）
SELECT * FROM student WHERE name <> '山田太郎';

（3）
SELECT * FROM resource WHERE price >= 3000;

（4）
SELECT code, name FROM resource WHERE price < 5000;


■例題3-4
（1）
SELECT * FROM resource WHERE price BETWEEN 2000 AND 3000;

（2）
SELECT * FROM resource WHERE class IN ('mdvd', 'pbbk');

（3）
SELECT * FROM student WHERE name LIKE '%田%';


■例題3-5
（1）
SELECT * FROM resource WHERE price < 2000 OR price > 3000;

（2）
SELECT * FROM resource WHERE class <> 'mdvd' AND class <> 'pbbk';

（3）
SELECT * FROM resource WHERE name NOT LIKE '__テキスト';
