More of Chapter 4

• Searching for NULL values

  • SELECT * 
    FROM EQUIPMENT 
    WHERE AcquisitionCost IS NULL;
           

• SELECT EquipmentType, count(*) AS count 
  FROM EQUIPMENT
  GROUP BY EquipmentTYpe 
  	HAVING count > 1;