Answer:
Self Join
Explanation:
Required
The type of JOIN
Notice that the given query joins the customer table and the order table without using the keyword join.
SQL queries that join tables without using the keyword is referred to as self join.
<em>Other types of join will indicate the "join type" in the query</em>
<span>1,048,576 is 1,024 times 1,024, 1,024 * 1,024 or 1,024 squared or 1,024^2. If a computer takes x amount of time to sort 1,024 elements then the relationship is a 1 to 1. Therefore the computer will take x times x or x^2 (x squared) amount of time to sort 1,048,576.</span>