Given the following table: I’m trying to fetch all statuses by host, with their relative percentage. In order to do that, I need to count results grouped by host and status, and divide each counted field by its total host fields count. For example, this query would have worked in MySQL: But ClickHouse t…
Tag: percentage
SQL relative percentage for each country
I have a table: maps_query like below: The question is to output the relative percentage of queries for maps_query for each country. Desired output is like below: I don’t quite understand what relative percentage is here but I assumed it’s asking to output (a country’s search_query counts/ a…
Using Over() with aggregate functions while calculating percentage
I am writing a query to print Total Students in each department in a college, I also want to print the percentage of those students in each department out of Total students in the college. Having issues with calculating percentage, the above query throwing an error dbo.Student.Id is invalid in the select list…
query to insert records to another table by calculating the percentage on a column
I have 2 Postgres tables with the following structure: Lets say I have data in the tmp table as below: I have a script below that inserts the data from public.tmp to public.mo table based on the criteria that if the column STATUS has mix values (COMPLIANT and NC) for a particular HOSTNAME then compliant_statu…
MYSQL Query calculate percentage of emails not null
I have these two queries. Caluculates count of emails that are null SELECT COUNT(*) as invalid_email FROM distinct_customers WHERE c_email IS NULL; Calculates count of every email SELECT COUNT(distinct c_number) as total FROM distinct_customers; I am trying to combine those to queries so that it gives me a pe…
Percentage from Total SUM after GROUP BY SQL Server
I have these results: With the table like: These are grouped by the person. Now I’m looking to add a column with the percentages for each person calculated from the total of all of their sums. For example: the total sum is 300, and hence I need a result like this: I have looked at code online and I have