I have a single line in MySQL table: volunteers user_id | start_date | end_date 11122 | 2017-04-20 | 2018-02-17 How can I find how many times the 3rd day or 24th day of a month appears? (i.e. 2017-05-03, 2017-06-03, 2017-12-24,…
I have 2 columns of type int and I want to make a concat to two columns in presto syntax. it is possible? for example: id: 345 997 age: 23 55 new_col: 34523 99755 I was trying to use the…
I have made a stored procedure in MySQL which accepts several arguments and does its things. And while I have no problem to execute the following query in MySQL CALL my_pr(var1, var2, var3); CALL my_pr(var4, var5, var6); When I try…
I have a temp_table with user_id and date and I want to find the DAU , WAU and MAU and I am querying this for that where: DAU - Count of active users for that day WAU - Count of…
So I have a table where a column that was given an auto_increment value accidentally got started form 300 instead of 1,2,3,4......i'm a beginner and i do not know how to change it back to 1,2,3,4......screenshot of table how to…
You are given a table, BST, containing two columns: N and P, where N represents the value of a node in Binary Tree, and P is the parent of N. Question - Write a query to find the node type…
In my Rails app, I have this scope which returns the Articles that have received the most views by joining the Ahoy Events table and my Articles table which is working. # article.rb scope :trending, (lambda do |time| joins(" INNER…
I have a WordPress multisite database, which has a lot of orphan tables I need to get rid of. The names are structured like this. The number in the table name is the site ID. wp_9892_wc_booking_relationships wp_10001_wc_booking_relationships wp_18992_wc_deposits_payment_plans wp_20003_followup_coupons wp_245633_followup_coupon_logs…
I would like to add a relative percentage to an SQL output Here is the code: SELECT customer_status.status AS "Status of Customer", COUNT (customer_bio), FROM customer_status JOIN customer_bio ON customer_status.status_id=customer_bio.status_id GROUP BY status Here is the output Status Number Switched…
I have a table like this: Table "*wallet" amount balance timestamp 1000 1000 2023-01-25 21:41:39 -1000 0 2023-01-25 21:41:40 200000 200000 2023-01-25 22:30:10 10000 210000 2023-01-26 08:12:05 5000 215000 2023-01-26 09:10:12 And here is the expected result: (one row per…