I have a SQL table of date entries with three columns: date, item, and status. The table appears like this: date item status 2023-01-01 A on 2023-01-01 B on 2023-01-01 C off 2023-01-02 A on 2023-01-02 B off 2023-01-02 C…
I have this working static query: SELECT companyname, companyid, incorporationcountryid, periodEndDate, filingdate, AVG(dataitemvalue) FILTER (WHERE menmonic = 'AT') as "AT", AVG(dataitemvalue) FILTER (WHERE menmonic = 'COGS') as "COGS" FROM aaa3 GROUP BY companyname, companyid, incorporationcountryid, periodEndDate, filingdate ORDER BY companyname,…
Let's say I have a table with Columns A, B, C, D, E and F. How would I query for entries where (A, B, C, D, E, F) = (1, 2, 3, 4, 5, 6) but only a subset of…
Given a data set of orders, I want to be able to get the distributors ranked in the top 200 based on the total amount of sales generated such that users having the same (total sales) figure are ranked equally:…
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, ',', ''))…