Suppose TableA has 10 rows and TableB has 10 rows and that TableA.id and TableB.id are primary keys of their respective tables. Do not assume any additional constraints.
SELECT *
FROM TableA a
INNER JOIN TableB b ON a.id = b.id
Give the minimum and maximum number of rows in the result set.