Query with the following logic

Question

Hello friends of the community. I need to fill a chart but I can’t assemble the query to receive the attributes, could someone help me? The query I need to do is the following.

select client.name, count(*) as Tickets 
from client, ticket 
where client.id = ticket.client_id 
group by client.id

Answer 1

Can you try:

use DB;
...
$dados = DB::select('select client.name, count(*) as Tickets 
from client, ticket 
where client.id = ticket.client_id 
group by client.id');