SQL

Consider a database that has the relation schema EMP (EmpId, EmpName, and DeptName). An instance of the schema EMP and a SQL query on it are given below.

EMP
EmpId  EmpName  DeptName
1      XYA      AA
2      XYB      AA
3      XYC      AA
4      XYD      AA
5      XYE      AB
6      XYF      AB
7      XYG      AB
8      XYH      AC
9      XYI      AC
10     XYJ      AC
11     XYK      AD
12     XYL      AD
13     XYM      AE

SELECT AVG(EC.Num)
FROM EC
WHERE (DeptName, Num) IN
      (SELECT DeptName, COUNT(EmpId) AS
                 EC(DeptName, Num)
       FROM EMP
       GROUP BY DeptName)

The output of executing the SQL query is ________.

Consider the following database table named *top_scorer*.

top_scorer
player       country     goals
Klose        Germany     16
Ronaldo      Brazil      15
G Müller     Germany     14
Fontaine     France      13
Pelé         Brazil      12
Klinsmann    Germany     11
Kocsis       Hungary     11
Batistuta    Argentina   10
Cubillas     Peru        10
Lato         Poland      10
Lineker      England     10
T Müller     Germany     10
Rahn         Germany     10

Consider the following SQL query:

SELECT ta.player FROM top_scorer AS ta
WHERE ta.goals >ALL (SELECT tb.goals
                     FROM top_scorer AS tb
                     WHERE tb.country = 'Spain')
AND ta.goals >ANY (SELECT tc.goals
                     FROM top_scorer AS tc
                     WHERE tc.country = 'Germany')

The number of tuples returned by the above SQL query is ________.