I know there are a few other similar questions out there, but I cannot seem to make this query work. I have a Rails 7 app with Recipe and Ingredient models joined through a Portions table (see models below). Given…
I am trying to count the unique values of a position_id while also satisfy another criteria of "true" in another column. I keep getting all values returned since I am counting them. COUNT(DISTINCT CASE WHEN p.position_id IS NOT NULL THEN…
I have a Postgres table like: id | value | category 0 | 10 | a 1 | 11 | b 2 | 50 | b 3 | 20 | a and I want the following (where the expression in…
I have a text field(Django) for the amount in the DB like amount = models.TextField(null=True, blank=True) SQL query select id, amount from payment order by amount asc; id | amount | -------+---------+ 12359 | 1111111 | ----> entered as "1111111"…
I have created a few nodes called routes and have given several relationships that are travel times as shown below. SELECT * FROM cypher('Map', $$ CREATE (a:Route {name: 'A'}), (b:Route {name: 'B'}), (c:Route {name: 'C'}), (d:Route {name: 'D'}), (e:Route {name:…
I havetwo table like this Table:customers Table:orders and want to display like join I've tried select concat(c.first_name, ' ', c.last_name) as customer_name, COUNT(o.customer_id) as total_orders, sum(o.amount) as total_amount_order from customers c join orders o on c.id = o.customer_id where o.amount…
I have a table in Postgres named personal_profit as shown below: date profit 2022-09-22 4000 2022-04-25 5000 2022-01-10 0 2022-02-14 0 2022-04-12 2000 2022-05-06 1000 2022-06-13 0 I want to get total profit ordered by month but starting with the…
As we know apache-age is built on top of PostgreSQL. I am curious about whether Apache Age supports multiple versions of the PostgreSQL protocol,including version 2, 3, and the extended query protocol (version 3.0). I am unsure whether these features…
How can I generate the equivalent of this (postgresql) query in eloquent WITH result as ( select *, order_id as alias_id from orders ) SELECT * FROM result; I should be able to pass the inner query as eloquent builder…
i have about 1300 CSV files with almost 40k of rows in each file, i have written a python code to read the file and convert all the 40k entries into single insert statement to insert in Postgres database. The…