I have 2 tables : urls and links.

```
urls
- urls.url

links
- links.source
- links.destination

```

I'm trying to select all the urls and add count of incoming and outgoing URLs, result should be :

```
URL; Count Incoming links; Count Outgoing links

```

I have tried the following to get the incoming URLs which sadly isn't valid SQL, and at this point I don't know how to look for the solution to this problem.

```
SELECT * FROM urls JOIN COUNT(links.source) ON urls.url = links.source 

```