I have these 3 tables: Drinks drink_id name Ingredients ingredient_id name Opskrifter drink_id ingredient_id quantity Drinks and Ingredients are cross-referenced in opskrifter. I want to return all recipes from opskrifter that have ingredients from another table called Stock name So to make a gin and tonic, I…
Tag: having-clause
Remove zero amount in a query
I have a table finalData with the following columns and data I am creating mysql query to display the income and expenses of Singapore per Area, but I have to exclude areas that has zero amount. Here’s the code I tried: Output should be like this Any help would be appreciated. Thanks Answer This logic w…
How to choose in postgresql rows where amount of one value is bigger than another? [closed]
Closed. This question needs debugging details. It is not currently accepting answers. Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question. Closed 2 years ago. Improve this question how t…
PostgreSQL – How to find the row with a record that matches it with a value higher than given value?
Let’s say I have two tables with a 1-to-many relation. Table A (user): id INT, name TEXT Table B (skill): id INT, user_id INT, skill_name TEXT, skill_level INT Each user may have multiple skills. And …
COUNT WHERE two conditions are met in the same column
I’m sure this has been asked before, but I can’t find a similar situation: Given a table ‘activity’ I need to count all users that have ‘SEM’ AND at least another channel IN contact_channel_ID Answer You can use aggregation and having: In MySQL, the having clause can be sho…
how to count all rows are approved in sql?
I have this line data, where it also shows the status: approved, in progress, not yet started. I need to count how many lines are ALL APROVED based on the line colors. the data is similar to this: the query should show that there is only color (which is green) that all the status are approved, because red sti…
MySQL: Join three tables, comparing two values
First of all, I’m an amateur on SQL. Here it is the example. From this three tables I would like to know who are the teachers that make more money than Mike Table1: Table2: Table3: So far I’ve made this: And I don’t know how to keep going because when I run it, an error appears. My expected …
How to get common value based on a column from a table sql
I have a table. the screenshot is given bellow: There have two columns item_details_id pay_method_id In item_details_id there have 1,2,1 data. On the other hand pay_method_id have 1,1,3 data. I want to get only common values of pay_method_id depending on item_details_id. According to the given screenshot- in …
How to exclude certain values from a Query [SQL]
as the title states, an NotPrimID, can have two different values Example 1 and Example 2 IF: if NotPrimID does have both values, it should be automatically excluded from the query result. What i want: Query, that will deliever all the NotPrimID, that only have “Example 1” as a result, however if N…
How to filter rows that has multiple condition MySQL
I have a table that contains my product details Now I want to write a query that gives me product_id(s) with this conditions: Brand = Intel model = Core i7 I’ve tried this one but it didn’t returns any rows, I guess I should use JOIN. Answer Use group by and having: Or better yet, using tuple equa…