I need to count a number of rows in one column that respond to one from two types of rows in other column while also aliasing them
the goal is to create a table with number of users of each app.
app1 users ***
app2 users ***
select count(users) where app = 'app1' as app1_users, count (users) where app = 'app2' as app2 users
should i use inner join for this?
I’m just starting and it seems an easy task but i’m stuck, please push me in the right direction