In the section "Domain-Constrained Comparisons," I showed an
SQL SELECT - FROM - WHERE expression that contained another
such expression nested inside it (a "subquery"). Now, each of the
SELECT clauses in the overall expression could have been
replaced by the arguably simpler form SELECT* ("SELECT star").
But "SELECT *" suffers from certain problems, which is why I
usuallynot invariablyavoid using it in this book. Identify as many
of those problems as you can. Can you think of any other
constructs in SQL that suffer from similar problems?