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…
I have a table named sales in a MySQL database that looks like this: company manufactured shipped Mercedes Germany United States Mercedes Germany Germany Mercedes Germany United States Toyota Japan Canada Toyota Japan England Audi Germany United States Audi Germany…
I am trying to updated the my.cnf file to increase the buffer pool size for a query I am running in python via mysql because I keep getting the error: OperationalError: 2013 (HY000): Lost connection to MySQL server during query…
I have a SQL query that sorts a table for a local restaurant into categories, but after that I would like to sort alphabetically by title. The end result should sort the categories, and then the content is sorted alphabetically…
I have the 2 following table : Source table with 2 columns (large number of records) : columnA columnB abcdez defghp azerty ghjklm ... ... Mapping table with source value and new value. All columnA and columnB values in the…
I've got a problem with a MySQL query. Suppose we have two tables: cars: id brand owner_id 1 toyota 24 2 ford 56 ... ... ... car_debts: id value car_id(fk) fl_unique(boolean) 24 50.0 1 0 25 40.0 1 0 26…