When I execute the following query, the name of any product appears, but not the product with the lowest price: SELECT MIN(Price), ProductName FROM Products; How could I see the name of the product with the lowest price? Thanks in…
I made a minimal example to describe my problem using the concept of player using items in a game (which makes my problem easier to understand). My problematic is the following. Let's say I have to store items and the…
I have a table called addresses, it has a column name user_ids which is an array of the users who have that same address. When I request to /api/addresses what it returns is {id:1,name:"lorem", user_ids:[1,2]}. I want it to return…
UPDATE work_info as info1 SET info1.status_id = 1 WHERE info1.info_id IN( SELECT info2.info_id FROM work_info as info2 WHERE info2.info_id IN ( SELECT MAX(info3.info_id) FROM work_info as info3 GROUP BY info3.user_license_id) AND info2.status_id = 5) Getting this error #1093 - You…
I have a user table like this, name week_no year_no fb 5 2021 twitter 1 2022 twitter 2 2022 twitter 3 2022 twitter 7 2022 youtube 21 2022 I want to find the names of users who login >= 3…
I have a table and a stored procedure like following, CREATE TABLE `inspect_call` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `task_id` bigint(20) unsigned NOT NULL DEFAULT '0', `cc_number` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `created_at` bigint(20) unsigned NOT NULL…
I am trying to filter a set of appartments by computing every possible surface the building has got, and then checking if it matches my criterias or not. Example : I have one building A that is composed of 3…
Description: We have two tables as below: table_1 ("question" main table) table_2 ("question_attempted" joining table) Cases: In "table_2" we have a column that has a column "is_correct" (holds 1,0) for right or wrong answers. In "table_1" we have 1 m…
I have two different situation, in small DB with 200 Row (So Simple) and in large DB with 2,000,000,000 Row (And adding more rows every day) I want select one or more row so in this case, which one is…
Run into sql code with a lot of when: case when callDuration > 0 and callDuration < 30 then 1.4 when callDuration >= 30 and callDuration < 60 then 2.3 when callDuration >= 60 and callDuration < 120 then 3.7…