What are the main advantages and disadvantages of SQL?

Question

Quizplus · Accepted Answer

The Answer is Advantages
Satisfies ideals for database language
(Relatively) Easy to learn
Portability
SQL standard exists
Both interactive and embedded access
can be used by specialist and non-specialist.
Disadvantages
Impedance mismatch - mixing programming paradigms with embedded access
Lack of orthogonality - many different ways to express some queries
Language is becoming enormous (SQL2 is 6 times larger than predecessor; SQL3 is even larger again)
Handling of nulls in aggregate functions
Result tables are not strictly relational - can contain duplicate tuples, imposes an ordering on both columns and rows.

What Are the Main Advantages and Disadvantages of SQL