Question: Table Creation
--------------

```
CREATE TABLE demo
( 
  id number(10) NOT NULL,
  ct number(10) ,
  CONSTRAINT id_pk PRIMARY KEY (id)
);

```

ROWS INSERTION
--------------

```
insert into demo(id,ct) values(1,4);

insert into demo(id,ct) values(2,2);

insert into demo(id,ct) values(3,3);

insert into demo(id,ct) values(4,2);

select * from demo

select q2.id,q2.ct from (
 select a1.id id,(SELECT sum(ct) from demo a2 
 where a2.id = a1.id) ct 
 from demo a1 ) q2 
group by q2.id

```

the above query is failing in one DB 

> 
> **ORA-00979: not a GROUP BY expression
>  00979. 00000 - "not a GROUP BY expression"
>  \*Cause:  
> 
>  \*Action: Error at Line: 1 Column: 14**
> 
> 
> 

In another db it is returning the results with counts

DB Version : 11.2.0.4.0

Both databases are running on same version. The results of the below query is same in both DBs

```
SELECT * FROM PRODUCT_COMPONENT_VERSION;

```

Answer: 
I think you are still calling V1 endpoint. In fact, the Beta endpoint is not currently supported in the Microsoft Graph .NET Client Library. More info [here](https://github.com/microsoftgraph/msgraph-sdk-dotnet/issues/108).
There is an official beta client for Graph API now:
<https://github.com/microsoftgraph/msgraph-beta-sdk-dotnet>