I want to insert in a ManyToMany relationship (between 'fiche' and quality) a line (same principle as a log) when an insertion fails because the key is duplicated. example: insert into fiche (content) values ('toto') on conflict (content) do insert…
I would like to use Postgres SQL to assign an age category to a list of househoulds, where we don't know the date of birth of any of the family members. Dataset looks like: household_id household_size x1 5 x2 1…
I have this table that lists which months each product is available on the market. For example product 1 is available from Mar to Dec and product 2 is available from Jan to Feb. product_id start_month end_month 1 3 12…
sorry for my English, how can I display the number of times of subscription of a member based on their (member id) in the database? because the output shows the number or times of subscription of all the members. so…
The scenario is a set of tables that contain data related to markets and goods produced at those markets. In the basic example below, you have Ice and this produces water. I have a SQL query which works well and…
What does this asterisk(*) mean? select employee_id, salary * (employee_id % 2) * (name not like "M%") as bonus from Employees order by employee_id;
I have a table which stores timestamps but they're in a jsonb array column like this: id cycles 5 [{"end": "2022-10-18T18:31:34.529667Z", "start": "2022-10-05T19:01:51.400124Z"}, {"start": "2022-10-28T08:27:13.682084Z"}] 6 [{"start": "2022-10-03T16:37:38.119236Z"}] 7 [{"end": "2022-11-14T11:30:17.964960Z", "start": "2022-11-08T19:20:20.413133Z"}] I need to the values from the…
I have 3 tables dogs, breeds and entries. I need to get AVG(score) from entries, Name from dogs and name from breeds. I have managed to connect 2 tables together and I'm struggle to get the last thing (breeds.name) attached…
I have Price_trend table in that m_id and c_id are foreign keys. I need m_id column 3,7 top two records. Her is my db-fiddle table: price_trend id c_id m_id date 1 1 3 2022-12-08 2 1 3 2022-12-06 3 1…
I want to select rows from a table where a column value lies in another column value of the same table. I am trying to execute code in Oracle SQL developer I have a larger input dataset similar to below…