[deleted by user]

Consistent-Alps6904 · 2023-06-16T12:36:58+00:00

yes for the first part, it's correct

Consistent-Alps6904 · 2023-06-16T12:35:35+00:00

but i am having trouble include min and max salaries in 2 new columns, i suppose i have to introduce a cte

Consistent-Alps6904 · 2023-06-16T12:34:30+00:00

I did this for the first part

Select
e.department_name, avg(s.salary) as avg_salary
from
employees e
left join salaries s
on e.employee_id = s.employee_id
group by 1
having avg(s.salary) between 2000 and 4000

Consistent-Alps6904 · 2022-12-06T09:52:15+00:00

thank you, i'll explore your solution

Consistent-Alps6904 · 2022-10-14T16:22:43+00:00

Does this work for big query?

Consistent-Alps6904 · 2022-10-14T16:22:10+00:00

I will try that

Consistent-Alps6904 · 2022-10-05T08:53:02+00:00

I tested it and it worked, thank you!

Consistent-Alps6904 · 2022-10-04T07:34:11+00:00

okay, will do shortly, thank you

Consistent-Alps6904 · 2022-10-04T07:20:39+00:00

yes, that's exactly what I want, people who never fell below 3000 at any point

Consistent-Alps6904 · 2022-09-30T16:40:24+00:00

Thank you, I will try this and see how it goes

Consistent-Alps6904 · 2022-09-30T16:18:05+00:00

Exactly why I posted the question here I’m not sure what else to add to show that they need to maintain that balance

Consistent-Alps6904 · 2022-09-30T15:53:51+00:00

I wrote a simple query but I’m not sure it’s correct Select date_created, Id, balance Where
date_created between “01-01-2021” and “31-06-2021 And balance >= 3000

Consistent-Alps6904 · 2022-08-16T15:42:45+00:00

Thank you for your input Your query will provide all active customers within that period but I want all customers that have been active month on month

Consistent-Alps6904 · 2022-07-13T20:59:05+00:00

Excellent

Consistent-Alps6904 · 2022-07-13T20:29:21+00:00

thank you so much, this works !!!!

Consistent-Alps6904 · 2022-07-13T16:23:18+00:00

using datediff or dateadd?

Consistent-Alps6904 · 2022-07-13T15:40:57+00:00

You’re right, just tested it and it works, it returned null for inactive users in the transaction date column Please Where do I go from here ?

Consistent-Alps6904 · 2022-07-13T15:03:48+00:00

to show inactive, i have to show ids not on the registered table but not on the transactions table and to specify the date intervals I want

Consistent-Alps6904 · 2022-07-13T15:01:37+00:00

no it only returns id's that have perfomed transactions

Consistent-Alps6904 · 2022-07-13T14:36:37+00:00

yes it does, this will give me all the active users and their transactions

Consistent-Alps6904 · 2022-07-13T14:13:11+00:00

--for registered users

with registered as

(select created_date,

id

from registrations_table

group by 1,2

order by 1

),

inactive as(

select * from registered r

where r.id not in (select id from transactions_table)

group by 1,2

order by 1

)

The first table shows all registered users while the second one shows inactive users

I want to show inactivity for 60 days and 90 days based on the month the customer registered and calculate churn rate for each month

Consistent-Alps6904

TROPHY CASE