Incorrect response for incorrect query

INSERT INTO Default.W1k1sZIoSemMMVnbzSf ([{'mutated': 0.0, 'country': 'Burkina Faso', 'padding': 'liDDYeWtGCKvoTveHzGZULCDFRbEJtEPgBdRtsqzouwWONFAAdubhYGWBTYHRkfAiKUPXiGPtvroqfzPnYycZqajiEfVjxYnpGjQrHR', 'address': '4202 Lopez Trafficway Apt. 799\nNew Scott, DC 96995', 'document_size': 10000, 'free_parking': 0, 'city': 'Jonesmouth', 'type': 'Hotel', 'url': 'http://www.kirk-larsen.net/', 'avg_ratings': 0.0, 'reviews': [{'date': '2019-11-05T17:22:49', 'author': 'Miss Joanne Berry', 'rating': {'cleanliness': 9, 'overall': 10, 'value': 0}}, {'date': '2016-03-19T13:45:11', 'author': 'Ricardo Rios', 'rating': {'cleanliness': 4, 'overall': 7, 'value': 10}}, {'date': '2017-02-01T09:14:30', 'author': 'Crystal Howard', 'rating': {'cleanliness': 9, 'overall': 2, 'value': 9}}, {'date': '2016-12-26T11:13:47', 'author': 'Stephanie Gonzalez', 'rating': {'cleanliness': 4, 'overall': 1, 'value': 5}}, {'date': '2023-02-11T06:18:30', 'author': 'Emily Jefferson', 'rating': {'cleanliness': 8, 'overall': 8, 'value': 9}}, {'date': '2014-09-13T01:31:09', 'author': 'Taylor Scott', 'rating': {'cleanliness': 10, 'overall': 2, 'value': 7}}, {'date': '2023-07-18T15:22:38', 'author': 'Richard Bryant', 'rating': {'cleanliness': 5, 'overall': 5, 'value': 9}}, {'date': '2016-07-02T21:10:25', 'author': 'William Hicks', 'rating': {'cleanliness': 0, 'overall': 1, 'value': 8}}, {'date': '2021-11-24T15:22:17', 'author': 'Kathy Barber', 'rating': {'cleanliness': 10, 'overall': 5, 'value': 1}}, {'date': '2021-03-10T01:30:35', 'author': 'Christopher Valdez', 'rating': {'cleanliness': 3, 'overall': 5, 'value': 2}}, {'date': '2017-08-22T19:36:44', 'author': 'Jill Lindsey', 'rating': {'cleanliness': 2, 'overall': 3, 'value': 7}}, {'date': '2015-03-15T22:26:55', 'author': 'Scott Franco', 'rating': {'cleanliness': 5, 'overall': 9, 'value': 4}}, {'date': '2016-05-08T03:16:34', 'author': 'Sherry Wright', 'rating': {'cleanliness': 10, 'overall': 7, 'value': 5}}, {'date': '2021-06-23T22:57:33', 'author': 'Vanessa Roberts', 'rating': {'cleanliness': 1, 'overall': 9, 'value': 8}}, {'date': '2019-02-11T08:35:02', 'author': 'Emily Hernandez', 'rating': {'cleanliness': 8, 'overall': 1, 'value': 1}}, {'date': '2022-07-20T13:48:29', 'author': 'Mercedes Parks', 'rating': {'cleanliness': 7, 'overall': 4, 'value': 7}}, {'date': '2020-07-08T02:40:39', 'author': 'Kevin White', 'rating': {'cleanliness': 7, 'overall': 6, 'value': 0}}, {'date': '2013-11-04T19:10:46', 'author': 'Lori Jenkins', 'rating': {'cleanliness': 1, 'overall': 2, 'value': 3}}, {'date': '2014-07-14T07:43:07', 'author': 'Mr. Jonathan Weber Jr.', 'rating': {'cleanliness': 5, 'overall': 7, 'value': 9}}, {'date': '2017-11-13T14:59:48', 'author': 'Robert Rodriguez', 'rating': {'cleanliness': 10, 'overall': 8, 'value': 10}}, {'date': '2019-06-21T04:25:21', 'author': 'Kristen Ballard', 'rating': {'cleanliness': 4, 'overall': 5, 'value': 6}}, {'date': '2018-08-16T07:38:25', 'author': 'Judy Parker', 'rating': {'cleanliness': 5, 'overall': 8, 'value': 7}}, {'date': '2016-03-03T06:10:35', 'author': 'David Morris', 'rating': {'cleanliness': 9, 'overall': 8, 'value': 0}}, {'date': '2017-08-18T21:16:19', 'author': 'Carmen Anderson', 'rating': {'cleanliness': 5, 'overall': 5, 'value': 9}}, {'date': '2017-11-18T07:20:24', 'author': 'Christopher Lopez', 'rating': {'cleanliness': 10, 'overall': 10, 'value': 5}}, {'date': '2022-07-09T14:26:25', 'author': 'Robin Hopkins', 'rating': {'cleanliness': 7, 'overall': 2, 'value': 7}}, {'date': '2017-01-16T17:42:49', 'author': 'Scott Melton', 'rating': {'cleanliness': 0, 'overall': 4, 'value': 0}}, {'date': '2016-05-13T17:09:46', 'author': 'Carl Long', 'rating': {'cleanliness': 2, 'overall': 2, 'value': 8}}, {'date': '2017-12-04T08:12:37', 'author': 'Leroy Austin', 'rating': {'cleanliness': 8, 'overall': 4, 'value': 0}}, {'date': '2022-10-29T19:22:08', 'author': 'Jeffrey Farrell', 'rating': {'cleanliness': 4, 'overall': 10, 'value': 2}}, {'date': '2016-07-06T07:34:57', 'author': 'Jeffrey Arnold', 'rating': {'cleanliness': 3, 'overall': 3, 'value': 1}}, {'date': '2019-04-14T21:05:37', 'author': 'Jeremy Marquez', 'rating': {'cleanliness': 5, 'overall': 2, 'value': 0}}, {'date': '2023-05-20T16:26:56', 'author': 'Angela Copeland', 'rating': {'cleanliness': 2, 'overall': 6, 'value': 4}}, {'date': '2017-11-28T12:55:09', 'author': 'Scott Jones', 'rating': {'cleanliness': 8, 'overall': 10, 'value': 0}}, {'date': '2016-03-11T18:51:44', 'author': 'Carrie Cooper', 'rating': {'cleanliness': 7, 'overall': 1, 'value': 7}}, {'date': '2021-11-22T01:57:08', 'author': 'Donna Miles', 'rating': {'cleanliness': 3, 'overall': 3, 'value': 3}}, {'date': '2022-05-23T13:31:14', 'author': 'Andrea Barnett', 'rating': {'cleanliness': 3, 'overall': 8, 'value': 8}}, {'date': '2021-03-21T11:04:58', 'author': 'Emily Guerrero', 'rating': {'cleanliness': 9, 'overall': 7, 'value': 1}}, {'date': '2015-10-11T08:45:37', 'author': 'Audrey Gonzalez', 'rating': {'cleanliness': 3, 'overall': 9, 'value': 0}}, {'date': '2019-03-29T00:59:42', 'author': 'Gabriel Morgan', 'rating': {'cleanliness': 8, 'overall': 9, 'value': 1}}, {'date': '2020-02-29T16:05:42', 'author': 'Stephanie Flowers', 'rating': {'cleanliness': 9, 'overall': 9, 'value': 3}}, {'date': '2021-07-08T23:22:42', 'author': 'Tracie Moses', 'rating': {'cleanliness': 0, 'overall': 3, 'value': 10}}, {'date': '2023-01-14T09:51:38', 'author': 'James Sims', 'rating': {'cleanliness': 6, 'overall': 7, 'value': 7}}, {'date': '2015-02-25T01:42:48', 'author': 'Sandra Anderson', 'rating': {'cleanliness': 2, 'overall': 5, 'value': 10}}, {'date': '2013-11-26T10:03:38', 'author': 'Julie Olsen', 'rating': {'cleanliness': 8, 'overall': 10, 'value': 8}}, {'date': '2015-01-02T01:16:20', 'author': 'Clinton Dyer', 'rating': {'cleanliness': 7, 'overall': 6, 'value': 6}}, {'date': '2021-11-18T00:17:05', 'author': 'Calvin Vance', 'rating': {'cleanliness': 4, 'overall': 8, 'value': 7}}, {'date': '2014-06-20T12:48:16', 'author': 'Robert Watson', 'rating': {'cleanliness': 6, 'overall': 4, 'value': 3}}, {'date': '2023-02-12T16:57:07', 'author': 'David Mcdaniel', 'rating': {'cleanliness': 5, 'overall': 4, 'value': 9}}, {'date': '2021-06-06T21:43:09', 'author': 'Laura Simpson', 'rating': {'cleanliness': 6, 'overall': 2, 'value': 10}}, {'date': '2023-08-13T12:57:44', 'author': 'Christopher Flores', 'rating': {'cleanliness': 10, 'overall': 1, 'value': 4}}, {'date': '2014-09-23T14:34:19', 'author': 'Richard Garza', 'rating': {'cleanliness': 3, 'overall': 6, 'value': 6}}, {'date': '2020-08-21T17:56:41', 'author': 'Timothy Riley', 'rating': {'cleanliness': 8, 'overall': 3, 'value': 2}}, {'date': '2018-06-30T17:28:54', 'author': 'Steven Harmon', 'rating': {'cleanliness': 8, 'overall': 6, 'value': 10}}, {'date': '2022-06-17T13:31:37', 'author': 'Caroline Harris', 'rating': {'cleanliness': 6, 'overall': 6, 'value': 3}}, {'date': '2019-04-07T05:49:31', 'author': 'Michelle Flores', 'rating': {'cleanliness': 7, 'overall': 1, 'value': 3}}, {'date': '2015-12-29T20:41:17', 'author': 'Connie Hammond', 'rating': {'cleanliness': 10, 'overall': 10, 'value': 8}}, {'date': '2020-08-02T09:52:14', 'author': 'Katherine Scott', 'rating': {'cleanliness': 9, 'overall': 7, 'value': 8}}, {'date': '2017-10-27T06:09:51', 'author': 'Michaela Vaughan', 'rating': {'cleanliness': 7, 'overall': 8, 'value': 4}}, {'date': '2018-08-18T03:53:31', 'author': 'Barbara Levine', 'rating': {'cleanliness': 2, 'overall': 1, 'value': 8}}, {'date': '2016-04-26T08:30:17', 'author': 'Peter Freeman', 'rating': {'cleanliness': 4, 'overall': 7, 'value': 3}}, {'date': '2015-02-02T06:20:33', 'author': 'Emily Chavez', 'rating': {'cleanliness': 5, 'overall': 1, 'value': 8}}, {'date': '2022-10-19T15:36:33', 'author': 'Jill Beard', 'rating': {'cleanliness': 0, 'overall': 3, 'value': 6}}, {'date': '2014-04-04T09:43:52', 'author': 'Claire Smith', 'rating': {'cleanliness': 1, 'overall': 3, 'value': 6}}, {'date': '2018-10-16T17:22:05', 'author': 'Robert Kennedy', 'rating': {'cleanliness': 2, 'overall': 5, 'value': 10}}, {'date': '2017-07-06T11:34:51', 'author': 'Adam Steele', 'rating': {'cleanliness': 4, 'overall': 5, 'value': 0}}, {'date': '2017-01-25T15:21:19', 'author': 'Scott Richardson', 'rating': {'cleanliness': 4, 'overall': 9, 'value': 7}}, {'date': '2015-07-08T02:55:39', 'author': 'Kelly Campbell', 'rating': {'cleanliness': 5, 'overall': 3, 'value': 7}}, {'date': '2018-03-18T15:29:11', 'author': 'Patricia Lowe', 'rating': {'cleanliness': 0, 'overall': 2, 'value': 3}}, {'date': '2018-12-10T10:25:07', 'author': 'Bryan Murphy', 'rating': {'cleanliness': 10, 'overall': 4, 'value': 8}}, {'date': '2021-08-19T11:43:46', 'author': 'Jasmin Richardson', 'rating': {'cleanliness': 0, 'overall': 9, 'value': 10}}, {'date': '2023-01-02T02:55:52', 'author': 'Dr. Laura Khan', 'rating': {'cleanliness': 7, 'overall': 5, 'value': 2}}, {'date': '2021-01-31T09:54:23', 'author': 'Joshua Wang', 'rating': {'cleanliness': 10, 'overall': 9, 'value': 6}}, {'date': '2013-12-31T06:36:14', 'author': 'Samuel Davidson Jr.', 'rating': {'cleanliness': 4, 'overall': 10, 'value': 3}}, {'date': '2016-01-17T09:53:51', 'author': 'Antonio Serrano', 'rating': {'cleanliness': 1, 'overall': 1, 'value': 10}}, {'date': '2020-12-29T02:17:50', 'author': 'Tanya Wong', 'rating': {'cleanliness': 6, 'overall': 3, 'value': 4}}, {'date': '2023-01-16T03:56:00', 'author': 'Michael Floyd', 'rating': {'cleanliness': 2, 'overall': 9, 'value': 9}}, {'date': '2017-07-18T04:53:08', 'author': 'Phillip Castillo', 'rating': {'cleanliness': 9, 'overall': 8, 'value': 10}}, {'date': '2015-11-17T18:00:21', 'author': 'Raymond White', 'rating': {'cleanliness': 6, 'overall': 4, 'value': 8}}, {'date': '2014-11-22T23:02:47', 'author': 'Dorothy Stewart', 'rating': {'cleanliness': 5, 'overall': 6, 'value': 1}}], 'phone': '428-852-7357x45193', 'price': 9000.0, 'free_breakfast': 1, 'name': 'Megan Buck', 'public_likes': ['Lance Wagner', 'Alicia Phillips', 'Elizabeth Palmer', 'Jeanette Lee', 'Christian Chung'], 'email': 'josephmartinez@smith-madden.com', 'key': None}]);

[

  {

    "code": 24045,

    "msg": "Cannot find analytics collection None in analytics scope Default nor an alias with name None (in line 1, at column 10038)"

  }

]

select count(*) from Default.W1k1sZIoSemMMVnbzSf;

[

  {

    "$1": 0

  }

]