Tabela visitsiduservisit_ts1Joao2022-01-20 10:20:002Maria2022-01-20 14:30:00Tabela purchasesiduserpurchase_ts1Joao2022-01-20 19:20:002Maria2022-01-20 14:30:003Jose2022-01-20 15:20:004Joao2022-01-20 16:30:005Joao2022-01-20 17:40:006Maria2022-01-20 18:30:00A tabela visits apresenta todos os usuários em quem se tem interesse e que visitaram determinado site. A tabela purchases, por outro lado, mostra todas as compras realizadas por todos os visitantes. As colunas que têm o sufixo _ts indicam data e hora em que o evento ocorreu.Considerando essas informações, assinale a alternativa correspondente à query que deve ser utilizada para retornar uma cópia exata da coluna user da tabela visits, acrescida de uma coluna que indique quantas compras cada usuário realizou.

Question

IADES · Accepted Answer

select a.user, count(a.id) as purchases_count from ( select a.user, b.id from visits a join purchases b on a.user=b.user ) a group by a.user

IADES · Answer

select a.user, a.id as purchases_count from ( select a.user, b.id from visits a left join purchases b on a.user=b.user ) a group by a.user

IADES · Answer

select a.user, count(a.id) as purchases_count from ( select a.user, b.id from visits a left join purchases b on a.user=b.user ) a group by a.user

IADES · Answer

select a.user, b.id from visits a left join purchases b on a.user=b.user

IADES · Answer

select a.user, a.id as purchases_count from ( select a.user, b.id from visits a left join purchases b on a.user=b.user ) a order by a.user

Tabela visitsiduservisit_ts1Joao2022-01-20 10:20:002Maria2022-01-20 14:30:00Tabela purchasesiduserpurchase_ts1Joao2022-0...

Questões relacionadas para praticar

Tabela visitsiduservisit_ts1Joao2022-01-20 10:20:002Maria2022-01-20 14:30:00Tabela purchasesiduserpurchase_ts1Joao2022-0...

Questões relacionadas para praticar

id	user	purchase_ts
1	Joao	2022-01-20 19:20:00
2	Maria	2022-01-20 14:30:00
3	Jose	2022-01-20 15:20:00
4	Joao	2022-01-20 16:30:00
5	Joao	2022-01-20 17:40:00
6	Maria	2022-01-20 18:30:00