I need to temporarily disable all constraints and triggers of a schema in order to anonymize data in several tables. As there are dependencies between tables, I prefer to disable everything and once the anonymization treatment is over I can…
I tried this but how to calculate for leap years. SELECT FLOOR(DATEDIFF(NOW(), date_of_birth) / 365.25) as years, FLOOR(MOD(DATEDIFF(NOW(), date_of_birth), 365.25) / 30.4375) as months, MOD(DATEDIFF(NOW(), date_of_birth), 30.4375) as days FROM employees; Can anyone please help
I'm trying to query for users with birthdays falling between a given date range. The users table stores birthdays in a pair of int columns: dob_month (1 to 12) and dob_day (1 to 31). The date range I'm querying with…
I need to pandasql library for doing some queries on my pandas dataframes. I have run the below code on a simple sample and got the following Error. Strangely, can't consider it as a query! I tried to reinstall, and…
I am relatively new to SQL and I am trying to extract rows where they have the highest values. For example, the table look like this: user_id fruits 1 apple 1 orange 2 apple 1 pear I would like to…
I have a column in my dataset with the following format: hashtags 1 [#newyears, #christmas, #christmas] 2 [#easter, #newyears, #fourthofjuly] 3 [#valentines, #christmas, #easter] I have managed to count the hashtags like so: SELECT hashtags, (LENGTH(hashtags) - LENGTH(REPLACE(hashtags, ',', ''))…
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…