Find new customer_ids for each day in an orders table. This means I want to compare each day with previous days to find the ones existing in that day but not in earlier day. Table: order_id order_date customer_id 1 2023-03-27…
I have a usecase on my studies for below example, i am struggling with the logic on how i can do a select statement to get all the records to display a student who failed in one or more subject…
I have defined a function: def findbasecoin(Ticker): mycursor.execute(f"SELECT `param_basecoin`.`Symbol` FROM `param_asset` INNER JOIN `param_pair` ON `param_asset`.`id_pair` = `param_pair`.`pair_id` INNER JOIN `param_basecoin` ON `param_pair`.`Coin2_id` = `param_basecoin`.`basecoin_id` WHERE `param_asset`.`Ticker` LIKE '{Ticker.lower()}';") for result in mycursor: result = result[0] When I do print(result),…
I have the following stored procedure in MySQL that reads a JSON array of objects and insert the objects in a JSON column of a temp table: DELIMITER $$ DROP PROCEDURE IF EXISTS proc_json $$ CREATE OR REPLACE PROCEDURE myProcedure(IN…
I need to write a trigger so that it counts the total purchase amount(total_price) in the purchase_data table, that is, multiplies the quantity(product_count) from the purchase_data table by the price of the product(product_price) from the product table. It is necessary…
I have a table, Account, which I am querying to identify old accounts based on sales records. An account may have multiple rows in a Property table. A property may be closed. If all properties on an account are closed,…
I have the following query: UPDATE `temp_table`, `sms` SET `sms`.`to` = `temp_table`.`new_value` WHERE `sms`.`to` = `temp_table`.`old_value`; temp_table has ~200,000 rows. sms has ~2,000,000 rows. sms.to, temp_table.new_value, and temp_table.old_value are VARCHAR(255) with indexes. Values are UK phone numbers. The update query…
I have a db fiddle in which I have a table. In this table, there are codes and their descriptions which are on the same field. i.e. for example if the code is 101 then its description MDI Reset is…
I'm trying to write an query that will analyze the data stored in Primary Keys across multiple tables to find if they contain unicode characters in them. Below are the schema of my tables: mysql> SHOW CREATE TABLE employee_plain; +----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+…
I want to count how much NULL data gets to the row with the contents of "resuss" Like that: open_date m+ id flag time hibernate 202203 202205 ax1 resuss 1 202203 202209 ax1 resuss 3 202203 202206 ay2 resuss 2…