Can someone help me understand what this SQL query is doing? select region_code, ST_Area(geom::geography) as area, ST_X(ST_Centroid(geom)) as long, ST_Y(ST_Centroid(geom)) as lat, latitude, longitude from regions where regexp_split_to_array(parent, E'\\.') && %s or region_code in %s More specifically I'm confused about…
INSERT INTO "public"."catalog_element" ("id", "catalogue_id", "element_id", "weight") VALUES (1,100,1,0), (2,100,2,1), (3,100,3,2), (4,10,1,0), (5,10,5,0), (6,10,6,1), (7,100,7,1); Let say, we have a Postgres table of catalog *- to -* element matching rows that are weighted, like such id catalogue_id element_id weight 1…
I've query which gives the results with a column name called alternative_time. It has the values like 2023-02-18 09:30:04 . I can do a query like NOW() -INTERVAL 7 DAY) and also time range like 03:00:00 and 10:00:00 but how…
I am new to the sql world and trying to archive a certain result. I have two tables: Table A contains, among other things, the following columns: Market_ID, Date, Event | Market_ID | Date | Event | | -------- |…
my output is look like: id order status item supplier confirm date customer Manager 555222 approved 12421 Hawi 12/02/2023 0122 George 555222 approved 12421 Hawi 12/02/2023 0122 Michael 555222 approved 12421 Hawi 12/02/2023 0122 Tom 543677 approved 85332 Mint 27/01/2023…
I have the following sample values; lst = [{'title': 'Guld för Odermatt i schweizisk dubbel', 'summary': '', 'link': '``https://www.dn.se/sport/guld-for-odermatt-i-schweizisk-dubbel/``', 'topic': ['empty', 'empty', 'empty', 'empty', 'empty', 'empty', 'SamhalleKonflikter', 'empty', 'empty', 'empty']} , {'title': 'Bengt Hall blir ny tillförordnad vd på Malmö…
Postgresql ver 15 Let's say I have a list of values, e.g. ID alpha beta delta . . . and I wish to check for each value, whether such a value exists in every group that is partitioned in a…
I have a database on sporting events whose schema can be summarized like this: Teams -------- id name Events ------- id nickname date team_1 (links to teams.id) team_2 (links to teams.id) Plays ----- id event (links to events.id) <other details>…
DB-Fiddle CREATE TABLE sales ( id SERIAL PRIMARY KEY, event_date DATE, sales_volume INT ); INSERT INTO sales (event_date, sales_volume) VALUES ('2023-01-27', '900'), ('2023-02-28', '500'), ('2023-01-29', '100'), ('2023-01-30', '600'), ('2023-01-31', '450'), ('2023-02-25', '300'), ('2023-02-26', '250'), ('2023-02-27', '845'), ('2023-02-28', '520'), ('2023-03-26', '750'),…
I want a query from my 3 table, but i dont know which JOIN should I use. I want to display all of table2's item_id and item_name, also show stat and shipped from table3 even if its NULL. Also, user_id…