I use PostgreSQL 14 to work on a student_books table which manages books borrowed by students. Each student can have zero or more books borrowed at any point in time. The table look like this (the order of rows doesn't…
In this dbfiddle demo I have a DELETE FROM... WHERE at the end like so: ...... DELETE FROM data_table WHERE (location, param_id, ref_time, fcst_time) NOT IN (SELECT location, param_id, ref_time, fcst_time FROM sel1) AND (location, param_id, ref_time, fcst_time) NOT IN…
So I can run two separate queries like this: SELECT date as date1, product as product1, product_id as product_id_1, SUM(revenue) AS rev1 FROM product_inventory WHERE date = '2021-11-17' GROUP BY date1 , product1, product_id_1 ORDER BY rev1 DESC SELECT date…
I have a Postgres DB, In which I am storing some analytical data in a table like a user id, city, country, source(referer), device_type(web, ios, android), etc. I wanted to show insights based on the data in the above table…
I have a mysql table with the following columns- Date, country, YEAR, MONTH, supercategory, class, corp_manufacturer, brand, license,item_description,amount, units, arp. Total number of records = 7.1 million Now i want to add a new column which shows the max value…
This might be difficult to explain. But Im trying to write a redshift sql query where I have want the count of organizations that fall into different market buckets. There are 50 markets. For example company x can be only…
My tables: questions id: serial content: text tags id: serial name: text questions_tags question_id integer tag_id integer I need to select all questions with tag 'css', but don't remove all other tags from JSON from jsonb_agg(). I have this SQL…
My table structure is roughly as described in this post: name processed processing updated ref_time abc t f 27794395 27794160 def t f 27794395 27793440 ghi t f 27794395 27793440 jkl f f 27794395 27794160 mno t f 27794395 27793440…
Here is the code of the (My)SQL function (it works outside of the function), but I can't manage to save it as a function for further reuse... This is an example of the working query: SELECT ( SUM(Items_Available * Store_Sales)…
I have a table with the following structure: name | version | processed | processing | updated | ref_time ------+---------+-----------+------------+----------+---------- abc | 1 | t | f | 27794395 | 27794160 def | 1 | t | f | 27794395…