Question: I'm trying to get the most recently modified file's (datetime - as a unixtimestamp) from a folder structure. There are many files but I only need the datetime of the most recently updated.

I'ved tried the following but I think I'm way of the mark:

```
stat --printf="%y %n\n" $(ls -tr $(find * -type f))

```

Answer: 
```
select f.lastname, count(m.firstname) as cnt
from familynames f
left join membernames m on m.id = f.id
group by f.id, f.lastname  
order by f.lastname

```
HERE Database names are prefixed to table names , DB1, DB2 are database names.

```
SELECT FN.lastName as 'Family Name', COUNT(*) as Members FROM 
DB1.familyNames FN
JOIN DB2.memberNames MN
on FN.ID = MN.ID
group by FN.lastName

```