/* Chapter 8 - Try It Out sections */
  
  /* Try It Out: Creating Expressions with Comparison Operators */
  
  SELECT DVDName, StatID
  FROM DVDs
  WHERE StatID='s2'
  ORDER BY DVDName;
  
  SELECT DVDName, StatID
  FROM DVDs
  WHERE StatID<>'s2'
  ORDER BY DVDName;
  
  SELECT DVDName, YearRlsd, StatID
  FROM DVDs
  WHERE YearRlsd>2000
  ORDER BY DVDName;
  
  SELECT EmpFN, EmpMN, EmpLN
  FROM Employees
  WHERE EmpMN IS NOT NULL;
  
  SELECT OrderID, TransID, DVDID
  FROM Transactions
  WHERE DVDID IN (2, 5, 8)
  ORDER BY OrderID, TransID;
  
  SELECT DVDName, StatID, RatingID
  FROM DVDs
  WHERE DVDName LIKE '\%horror%'
  ORDER BY DVDName;
  
  SELECT DVDName, StatID, RatingID
  FROM DVDs
  WHERE DVDName REGEXP 'ro'
  ORDER BY DVDName;
  
  /* Try It Out: Creating Expressions with Logical Operators */
  
  SELECT DVDName, MTypeID, RatingID
  FROM DVDs
  WHERE RatingID='G' OR RatingID='PG'
  ORDER BY DVDName;
  
  SELECT DVDName, MTypeID, RatingID
  FROM DVDs
  WHERE StatID='s2' AND (RatingID='G' OR RatingID='PG')
  ORDER BY DVDName;
  
  SELECT DVDName, MTypeID, RatingID
  FROM DVDs
  WHERE StatID='s2' AND NOT (RatingID='G' OR RatingID='PG')
  ORDER BY DVDName;
  
  /* Try It Out: Creating Expressions with Sort Operators */
  
  SELECT DVDName, StatID, RatingID
  FROM DVDs
  WHERE DVDName REGEXP 'W'
  ORDER BY DVDName;
  
  SELECT DVDName, StatID, RatingID
  FROM DVDs
  WHERE DVDName REGEXP BINARY 'W'
  ORDER BY DVDName;