Why SQL is not relational: Bags, not Sets

• SQL is based on bags (multisets), not sets
• A bag can have duplicate tuples (rows)
• SQL does not require that a table have keys
• Results frequently contain duplicate tuples (rows)
• Bag math is much more complicated than set math
• Probably the biggest failure of SQL