synatic / noql Goto Github PK

select id,First Name,Last Name,sumArray(Rentals,saleId) as totalIdRentals from customers

select * from (select id,First Name,Last Name,arrayLength(Rentals,'id') as rentalCount from customers) as t

Is there a way to achieve a NOT LIKE statement? Thanks!

select cast(a as Int) as s from collection

select count(*) as theCount from collection

should add a last pipeline stage

{
$count: "theCount"
}

But need to double check when grouping by different fields

https://docs.mongodb.com/manual/reference/operator/aggregation/count/

SELECT *,convert(id,'int') as idConv FROM customers

Only supported with aggregation, needs to be tested for

 select * from bob

returns:

{
    "limit": 100,
    "collection": "bob",
    "type": "query"
}

as expected.

However,

 select * from bob;

throws an error:

No FROM specified

select (log10(3) * floor(a) + 1) as s from collection

Please add support for CURRENT_DATE().

I currently get Error: Function:CURRENT_DATE not available.

My query:

SELECT COUNT(*) as count, MONTH(data.returnDate) as month 
FROM package 
WHERE YEAR(data.returnDate) = YEAR(CURRENT_DATE()) 
GROUP BY MONTH(data.returnDate)