Question: I'm very new in this and my question might be very stupid, please forgive me. 

So I'm working on an e-commerce website that will have multiple sellers displaying their products in one store, there will be a function to display the name of the seller like this "Sold by: Xavier". So what I want to do is let the word "sold by" be in different colour and the seller's name should be in a different colour too.
Take a look at my codes below, it will display "Sold by: Xavier" but in only one colour (black).

```
<span style="color:black;">Sold by: {{$product->seller->username}}</span><br>

```

Answer: 
You seem to be saying you want a list of cities that have hosted at least 3 different artists, but the query you provided doesn't do that, it just links the concert table to itself 3 times in identical manner. This link will always succeed in the same way and essentially is a non operation, because it asks if the table has data that exists in itself- something true for any database table with at least one row

That's why your logic doesn't work, but for a query that works something more like:

```
Select city from concert group by city having count(distinct artist)>= 3

```

May be more appropriate
You want cities that have seen three of the *same* artist. You should be thinking `group by`. In this case, you can get all such pairs of cities and artists using:

```
Select city, artist
from concert
group by city, artist
having count(*) >= 3;

```

If you just want cities where this has occurred, but you don't care about the artist:

```
select distinct city
from concert
group by city, artist
having count(*) >= 3;

```

The `select distinct` is because the city could have had 3+ concerts with more than one artist.

EDIT:

Based on your comment, you want three *specific* artists. That is not quite the same and quite unclear because your original question doesn't show any artist names.

You can easily do this with `group by`/`having`:

```
select city
from concert
where artist in ('Kanye', 'Jay-Z', 'Kendrick')
group by city
having count(distinct artist) >= 3;

```