I'm trying to query distinct Update_Date but also return a column that counts the total number of distinct Update_Date The table right now (Only Update_Date is
I need your help with the next problem, i need that a python recieve an string "EEEEDDSGES" and the output would by the sum of charactes that repeat in line, E
I tried to count rows with from 2 different table. the scenario is If status on tbl_task waiting, this job will not yet got the sales_id from tbl_sales. Once th
so I have a spreadsheet with name, email and phone number now I'm using another service to verify those emails but the problem is that the software is returning
Hi I want to know the index of the purchase number of a client based on the purchasing date. Starting table So I want to count the purchases made by each person
So I need to count the number of occurrences of a value per year, per animal. I've managed to do it but it's outputting a single column kind of dataframe rather
in Google Sheets I'd like to format an area of cells automatically by comparing its date value to another cell. In fact, I have some cells representing a month
I am trying to find percentage based on id column. issue - I am trying to use count(column)/select count(column) from table which is giving output as 'Zero' Tab
I have 3 tables, Property managers, Addresses and Units. I'm trying to get all the rows using the aggregate function COUNT, but it only returns 1 row. I want to
I have index with following mapping { "mappings": { "properties": { "typed_obj": { "type": "nested", "pr
I need to count values on a table accordingly with their presence or missing. With a clear example consider a table with 2 field: +-------+---------+ | K |
I try to query from other sheet using vlookup() or something similar. I want to count how many array it will produce. How can i find the length of the output or
I have a set of data for some tickets, with datetime of when they were opened and closed (or NULL if they are still open). +------------------+-----------------
I have some sqlalchemy that counts rows with the value "3" and then prints out the count. It works fine if the count is 1, 2, 3, etc, but when there are no item
I have presence points of a certain species all over the United States. I completed a spatial join between the US and said points. However, I am unsure of how t
I'm using SAS and I'm stuck when I want to relay this in SQL : I have a column that counts the number of line repetitions : DUPLICATES | NUMBER | DATE ------
I'm working on a challenge which basically consist on assigning to a set of rows and columns on a table, a value by a function in python. In this case the chara
Suppose I have the following table "Person": id name friends 1 matt jim 1 matt ray 1 matt ray 2 tim fry 3 sally jack 3 sally tim 4 matt harold I want to outpu
I would like to count the frequency of a value for the past x days. In the example below, I would like to count the frequency of value in the Name column for th
I need to use window function that is paritioned by 2 columns and do distinct count on the 3rd column and that as the 4th column. I can do count with out any is