Result[] when I use a query with where clause

using: SELECT * FROM Customers. It can get results.
[
{
“Customers”: [
{
“address”: {
“city”: “St. Louis, MO”,
“street”: “201 Main St.”,
“zipcode”: “63101”
},
“custid”: “C13”,
“name”: “T. Cruise”,
“rating”: 750
},

But if I want to:
SELECT * FROM Customers as c
where c.name = “T. Cruise”

{
“results”:
}

No idea what’s going on.

Customers is ARRAY . You must do UNNEST( i.e. FLATTEN) the ARRAY

SELECT uc.*
FROM Customers AS c
UNNEST c AS uc
WHERE uc.name = "T. Cruise";

OR

SELECT *
FROM Customers AS c
WHERE c[0].name = "T. Cruise";