 ■Sample501
SELECT * FROM purchase_history;

■Sample502
SELECT * FROM purchase_history
LEFT OUTER JOIN resource
ON purchase_history.code = resource.code;

■Sample503
SELECT * FROM purchase_history
RIGHT OUTER JOIN resource
ON purchase_history.code = resource.code;

■Sample504
SELECT * FROM purchase_history LEFT OUTER JOIN resource USING (code);

■Sample505
SELECT * FROM purchase_history RIGHT OUTER JOIN resource USING (code);

■Sample506
SELECT * FROM purchase_history INNER JOIN resource USING (code);

■Sample507
SELECT
  date AS '日付',
  code AS '商品コード',
  IFNULL(name,'<< 該当なし >>') AS '商品名',
  num AS '販売数'
FROM purchase_history
LEFT OUTER JOIN resource USING (code);

■Sample508
SELECT
  IFNULL(date,'--') AS '日付',
  code AS '商品コード',
  name AS '商品名',
  IFNULL(num,0) AS '販売数'
FROM purchase_history
RIGHT OUTER JOIN resource USING (code);

■Sample509
SELECT
  date AS '日付',
  resource.name AS '商品名',
  class_name.name AS '商品カテゴリ',
  num AS '商品数',
  price AS '単価'
FROM purchase_history
INNER JOIN resource USING (code)
INNER JOIN class_name USING (class);

■Sample510
SELECT * FROM resource
WHERE class = (SELECT class FROM class_name WHERE name = '教科書');

■Sample511
SELECT class FROM class_name WHERE name = '教科書';

■Sample512
SELECT * FROM resource WHERE class ='text';

■Sample513
SELECT * FROM resource
WHERE class= (SELECT class FROM class_name WHERE class LIKE 's___');

■Sample514
SELECT class FROM class_name WHERE class LIKE 's___';

■Sample515
SELECT * FROM resource
WHERE class
IN (SELECT class FROM class_name WHERE class LIKE 's___');

■Sample516
SELECT * FROM resource
WHERE class =
ANY (SELECT class FROM class_name WHERE class LIKE 's___');

■Sample517
SELECT * FROM resource
WHERE class =
SOME (SELECT class FROM class_name WHERE class LIKE 's___');

■Sample518
SELECT name,price FROM resource
WHERE price > ALL(
  SELECT AVG(price) FROM resource
  GROUP BY class HAVING COUNT(class) >= 2
);

■Sample519
SELECT AVG(price) FROM resource
GROUP BY class HAVING COUNT(class) >= 2;

■Sample520
SELECT name, price FROM resource
WHERE price > 2733.3333 AND price > 5150 AND price > 2650;

■Sample521
SELECT code, name, price
FROM (SELECT * FROM resource WHERE class = 'text') AS text;

■Sample522
SELECT * FROM resource WHERE class = 'text';

■Sample523
SELECT code, name, class, price FROM text;

■Sample524
SELECT code, name, price
FROM (SELECT * FROM resource WHERE class = 'text');



■例題5-1
SELECT
  code AS '商品コード',
  IFNULL(name,'<< 該当なし >>') AS '商品名',
  SUM(num) AS '販売数'
FROM purchase_history
LEFT OUTER JOIN resource USING (code)
GROUP BY code;

■例題5-2
（1）
SELECT 
  code,
  name, 
  price
FROM resource
WHERE name LIKE '英語%';

（2）
SELECT name, grade 
FROM student WHERE grade <> 1;
