SQL - separation of two results

Question

I have two queries below, both of which are loaded from the same "player" table. I want to split query 1 into query 2 to get the appropriate percentage. I am relatively new to more detailed SQL queries, as well as posting on forums ... but please let me know if you have any suggestions on combining this to get the appropriate percentage result.

1

Select sysdate,sum(Count(init_dtime)) From Player p Where Trunc(Init_Dtime) > Trunc(Sysdate) - 7 And Trunc(Create_Dtime) >= To_Date('2012-mar-01','yyyy-mon-dd') and trunc(create_dtime) < to_date('2015-sep-9','yyyy-mon-dd') Group By Trunc(Init_Dtime) Order By Trunc(Init_Dtime) Asc 

2

 Select Sum(Count(Create_Dtime)) From Player P where Trunc(Create_Dtime) >= To_Date('2012-mar-01','yyyy-mon-dd') And Trunc(Create_Dtime) < To_Date('2015-sep-9','yyyy-mon-dd') Group By Trunc(create_Dtime) Order By Trunc(create_Dtime) Asc 

Answer 1

You can just say

 select sysdate, count((init_dtime)) / sum((Create_Dtime)) * 100 as percentage from Player p where Trunc(Init_Dtime) > Trunc(Sysdate) - 7 and Trunc(Create_Dtime) >= To_Date('2012-mar-01','yyyy-mon-dd') and trunc(create_dtime) < to_date('2015-sep-9','yyyy-mon-dd') order by percentage asc 

group by in SQL files is not required because you are not really grouping something. group by is useful when you need a player percentage. Then you say group by player_id , and select will have player_id :

 select player_id, count(…) from … where … group by player_id 

EDIT: If the where clauses are different:

 select sysdate, ( (select count((init_dtime)) from player p where trunc(Init_Dtime) > trunc(Sysdate) - 7 and Trunc(Create_Dtime) >= To_Date('2012-mar-01','yyyy-mon-dd') and trunc(create_dtime) < to_date('2015-sep-9','yyyy-mon-dd')) / (select count((Create_Dtime)) from player P where trunc(Create_Dtime) >= To_Date('2012-mar-01','yyyy-mon-dd') and trunc(Create_Dtime) < To_Date('2015-sep-9','yyyy-mon-dd')) ) * 100 as percentage from dual