I am trying to get the category of specific students health inspection for each month. However, sometimes there are multiple entries for a month. How do I get the latest entry for the month using SQL? Below is the SQL…
I have issue with connecting to airflow database I can do it locally with such code import pandas as pd from sqlalchemy import create_engine import os df = pd.read_csv('wynik_zgloszenia.csv', sep = '#') engine = create_engine(f'postgresql+psycopg2://postgres:mysecretpassword@localhost:8001/postgres',client_encoding='utf8') df.to_sql('permissions', engine, index=False, if_exists='replace') I…
I'm encountering an issue with the SQL COUNT function that I need assistance with. Here's the scenario: In my database, I have two records with values '-try' and '-try2.' However, when I use the COUNT function in my SQL query,…
`I am having an issue with a Quiz I am developing where I am logging the Score count at the end of each game. At the end of the game, I sent a PUT request to update my totalscore in…
I can't connect to instance of cloud sql via pgAdmin. It says connection timed out. I know this could be due to the port 5432 not opened on the firewall, but in the Cloud SQL instance there's no firewall tab…
Based on this question and answer how is the query modified to return the user's name from a foreign table rather than the id? Here's the sql from the answer of the linked thread: SELECT user_id, round(avg(score)::numeric, 2) AS sc_avg…
I'm trying to create a function in PostgreSQL to get data from a table in a dynamic way, but if i update the structure of "my_table_2023", it will raise the error because the structure doesn't match: ERROR: structure of query…
I have 2 models. Database management system Postgres model Product { id Int @id @default(autoincrement()) name String @unique description String? options Option[] @@map("products") } model Option { id Int @id @default(autoincrement()) title String? description String? productId Int product Product @relation(fields:…
In PostgreSQL, I am attempting to fetch the previous Thursday and the previous Wednesday based on a thursday date (for example 2024-01-18). I have tried the following queries: For the previous Thursday: SELECT date_trunc('week', '2024-01-18'::date) - INTERVAL '5 days' AS…
How do we query for a particular fields in an array element inside a json string The column datatype is JSONB Sample json { "data" : [ { "begin" : "..." }, { "inter" : "..." }, { "inter" :…