sql

I have 2 tables made like so: NickName Points Player 1 15 Player 2 8 NickName Points Player 1 33 Player 2 22 and I need to get this table: NickName Points Player 1 48 Player 2 30 Is it…

I'm trying to categorize a certain entity, let's say, a User, with the most frequent value associated in a table to this entity, let's say, an Emotion. Thus,a User will be categorized as "Sad" when he logs mostly the value…

I have the following data of date and color in a mysql database 2023-01-28 red 2023-01-29 blue 2023-01-30 blue 2023-01-31 red 2023-02-01 blue 2023-02-02 blue 2023-02-03 blue 2023-02-04 blue 2023-02-05 red How can I pull the closest date to current…

I have the following tables defined by: CREATE TABLE db.books ( id INT auto_increment not NULL, title varchar(100) NULL, category_id INT NULL, PRIMARY key (id) ) CREATE TABLE db.books_categories ( id INT auto_increment not NULL, category varchar(100) NULL, PRIMARY key…

I need to reduce query time from 1.3sec to 0.1sec. if I don't compare sum(amount) with sum(pd.amount_take) my query time is 0.03sec My Code sql: SELECT p.po_id, date_format(p.po_date,'%d-%m-%Y') AS po_date, p.branch_id, b.fullname as branch_send, p.branch_id2, bb.fullname as branch_recieve FROM tbl_po_branch…

I am solving the SQL problem from Leetcode: 178. Rank Scores.. The question of the leetcode is this: Write an SQL query to rank the scores. The ranking should be calculated according to the following rules: The scores should be…