I have tables named course, student and students_in in a MySQL database. The tables look like this: course course_id name 3 Physics 12 English 19 Basket Weaving 4 Computer Science 212 Discrete Math 102 Biology 20 Chemistry 50 Robotics 7…
I have the following query: UPDATE items SET quantity = quantity - 1 WHERE quantity > 0 AND user_id = $1 AND item_id IN (5, 6, 7); I'd like to modify it such that the update will only occur if…
SQL Query like this below select json_build_array( json_build_object( 'entegrator_name', e2."name", 'provider_name', p."name", 'table1_count', count(t1.id) ) ) FROM table1 AS t1 JOIN entegrators AS e2 ON e.entegrator_id = e2.id JOIN providers AS p ON e.provider_id = p.id GROUP BY e2."name", p."name"…
I have a two-column table: product name cars ["bmw", "mazda", "ford", "dodge"] fruit ["lemon", "orange", "lime", "apple"] I'm using a wildcard to search the product's name column. My question is, is there a way to search a column only by…
Table A: id status 1 1 2 4 Table B: id status a_id 1 1 1 2 3 1 3 5 2 Table A ( id int, status int); Table B( id int, status int, a_id int foreignt key reference…
Under spu_pricebucket there are 5 different pricebuckets. I want to change it so each pricebucket will have its unitprice below it. End goal is to turn this table from 6 columns and 10 rows to 9 columns and 2 rows,…
I have two columns date and sales and the objective is to use case statement to create another column that shows the cumulative sum of sales for each date. Here's the sales table date sales 2019-04-01 50 2019-04-02 100 2019-04-03…
I'm trying to assign an ID code by searching for the name. update db.request r set s.CreateByID = ( select r.ID from db.user u where r.NameCreateBy = u.Name ) where r.ID in (23506); How would I put a case clause…
Here is the problem from leetcode: Table: Users +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | name | varchar | +---------------+---------+ id is the primary key for this table. name is the name of…
I'm using redash and my table looks something like this. I'm just learning sql. This is very advanced for me. I searched many questions, no queries worked for me |user_id | long | lat | |1 |31.000|26.000| |2 |30.000|25,000| |3…