i have this table called RELEASE:

```
*Country, Album, Date_year, Date_month, Date_day*
  Italy    Z      1940       2           27
  Italy    Y      1992       11          22
  Italy    X      1940       1           20
  Italy    R      1998       null        null
  France   W      1944       9           18
  UK       L      1989       8           21
  UK       P      1970       10          1
  Germany  E      2002       null        null

```

I need to specify a SQL query that take the **name of album**, the **name of country** and the **date (year, month, day)** of the **oldest album**.

(it's ok also if the values of month and day are null)

I can't use **LIMIT, OFFSET, ROWNUM**... i can use only standard SQL constructs.

I try to make this query but **it isn't correct**:

```
SELECT country, album, min(date_year), min(date_month), min(date_day)
FROM release

```

---

The result it would be:

```
 *Country, Album, Date_year, Date_month, Date_day*
  Italy    X      1940       1           20

```

---

How i can solve? Thanks