```
Table Name : Employee
    +------+------+
    | name | dept |
    +------+------+
    | ABC  | 1    |
    | BCA  | 1    |
    | CYZ  | 2    |
    | CYZ  | 1    |
    | n... | n... |
    +------+------+

Table Name : Department
    +----+-----------+
    | id | dept_name |
    +----+-----------+
    | 1  | YYY       |
    | 2  | ZZZ       |
    | 3  | DDD       |
    +----+-----------+

```

I've to select 25 random entries against each dept\_name from table `Employees`.
For eg. In table `Department` there are 10 entries with unique id.
so the result query will return `25(random) * 10 = 250` rows.

so far I'm working out this query but something is wrong with it.

```
Select * from Employee where dept in (Select id from Department) RAND;

```