Please help a MySQL newbie:

I have 2 tables:

```
assets

asset_id |  description
------------------------
001      |  Crate of Laptops
002      |  Crate of OhBots
003      |  Crate of Spheros

bookings

id       | asset_id   |  start_date     |     end_date   |   location
----------------------------------------------------------------------
1        | 001        |    2018/10/01   |   2018/10/10   |   Barnet
2        | 001        |    2018/10/12   |   2018/10/15   |   Hendon
3        | 002        |    2018/10/01   |   2018/10/10   |   Finchley
4        | 001        |    2018/12/01   |   2018/12/04   |   Brent

```

I need to show all of the latest bookings for each asset with a start date smaller than today - so if the date today is 2018/10/19 it should give me details for booking ids:

```
asset_id     |       location
------------------------------
001          |       Hendon
002          |       Finchley

```

So far I have this, but it doesnt show the latest booking - it shows all of them. I think I need a sub query using MAX() but cannot get that to work. There are a number of posts on how to get the latest values from a table, but I also need start\_date to be in the past.

```
SELECT asset.asset_id, asset.description, booking.location, booking.start_date
FROM  assets AS asset
INNER JOIN bookings AS booking 
ON asset.asset_id=booking.asset_id
WHERE booking.start_date <= NOW()
ORDER BY asset.asset_id DESC;

```