Exercise #16 (tips and solutions) |
||
Redundancy decision 1.12.2 can be eliminated, if to remove the subquery and create join between tables P and L. In this case, the request will not only compact, but easily readable and, most importantly, more effective. Here is an example of a hard to read, although the correct solution, which is published on the site's forum:
I think this is a good example of not good queries. To return to discussion of exercise #16 To solve a problem on SQL-EX.RU |