I have **two SQL queries** from same table as follows.

```
Query1 -> select * from (select (start_date::text), (end_date::text), count("NEW") "NEW" from table_name where refnum in (select refnum from table_name where start_date in (SELECT start_date FROM table_name ORDER BY ID DESC LIMIT 1)) and "NEW">0 group by start_date, end_date order by end_date DESC limit 10) top_10 order by end_date ASC

Query2 -> select * from (select (start_date::text), (end_date::text), count("DELETED") "DELETED" from table_name where refnum in (select refnum from table_name where start_date in (SELECT start_date FROM table_name ORDER BY ID DESC LIMIT 1)) and "DELETED">0 group by start_date, end_date order by end_date DESC limit 10) top_10 order by end_date ASC

```

Please suggest a final query to merge these two sub queries resulting in one single table

I want the final table containing columns **start\_date, end\_date, NEW, DELETED**