Advertisements The task is list of countries that has more than 10 customers I’m trying to show only the values that count > 10 in the table I’ve tried this but its not filtering the table: select co.country, count(*) from sakila.country as co inner join city as ci on co.country_id = ci.country_id inner join address… Read More MySql order by count(*)

Advertisements We have a table that is storing Sales History for Part numbers by Branch. Part #s can exist in one, or many Branches. Columns include the Current month, and 3 previous months. I need to write a SELECT query that will list all the Part #s that have zero Sales History in ALL Branches.… Read More Querying a table with no Key field

Advertisements I have students work system. Each student can submit multiple assignments, and the assignments are either written or practical. For each student, I need to know who has ONLY submitted practical work, no written work. I have two tables in use: assignments and workTypes. assignments looks something like this (excuse date format): userid workID… Read More MySQL count group_concat using case

Advertisements Not sure why this isn’t working. When I run the query without HAVING segment ilike ‘Enterprise’ I get results (see screenshot) but when I add it back in the query returns nothing despite clearly containing instances where segment = ‘Enterprise’. I can’t find any instances online where having is used to filter for strings… Read More SQL – After group by filtering down to rows where column value = certain string

Advertisements I’m trying to aggregate data from two tables and having trouble displaying it correctly. I searched for an answer to my question on stackoverflow, MySQL documentation, and several tutorials with no luck. Anyway, here’s what I got. SELECT works_with.client_id AS ‘Client ID’, client.client_name AS ‘Client Name’, works_with.total_sales AS ‘Total Sales’ FROM works_with JOIN client… Read More MySQL | Trouble Combining JOIN, GROUP BY, and HAVING SUM

Advertisements I am trying to use a query to return the count from rows such that the date of the rows matches the maximum date for that column in the table. Oracle SQL: version 11.2: The following syntax would seem to be correct (to me), and it compiles and runs. However, instead of returning JUST… Read More Oracle SQL — Finding count of rows that match date maximum in table

Advertisements I have to remove/skip the 1st records or max id in group_concat MYSQL. Here is query select email, group_concat(id order by id desc) as id from api_admin.external_user group by email having count(1) > 1; >Solution : Your GROUP_CONCAT() returns a string which is a comma separated list of at least 2 ids (because of… Read More Is there possible to remove 1 records or max(id) from GROUP_CONCAT MYSQL