A view is a virtual table drew up up of information from what i read in base tables and further views, but not stored separately.
An outer join includes rows of tables when there are no matching market value in the Tables
Sub some is a selected that drives in conjunction provided an additional specific A nested chosen is a type of Sub Select at which the inner pick passes to the at which standards for the outer select.
Group by controls the presentation of the rows, form by controls the presentation of the columns for the consequences of the SELECT statement .
The explain statement gives data just about the optimizer’s selection of entrance way of the SQL