Table A: (columns: id (integer), name (varchar), ...) Table B: (columns: id (integer), a_id (integer), value (numeric), ...) Table C: (columns: id (integer), a_id (integer), b_id (integer), date (date), ...) SELECT A.name, SUM(B.value) AS total_value, COUNT(DISTINCT C.date) AS distinct_dates FROM…
Let's say I have a database with columns name, last_name and type They're all strings, though type can only be TYPE_A, TYPE_B or TYPE_C I want a row in the database to be Unique when name and last_name already exist.…
How do I select a database entry who has the highest value in multiple columns? (PostgreSQL) I have a horse racing database and two tables I joined together in this statement. Then I sorted the values I want by a…
I have a database where i store all of my users that log in into my website and wanted to make it possible for them to delete their acc. So i made a function that works and can delete users…
I'm very new to qlik sense - I have some database experience. A team mate of mine recently quit who was the main owner of this piece of code. num(sum({1<[report_date] = {"=$(=(date((currDate))))"}> +1<[report_date]={"=$(date(currDate) - 7)"}> +1<[report_date]={"=$(date(currDate) - 30)"}> } anomoly_count…
We have a table called "subscriptions" that stores information about salon subscriptions. The table has the following columns: subscriptions id, start_date, end_date, subscription_plan_id, salon_id We want to write a query that provides the following information for each month: Date Total…
I have the following structure in the database: { "_id": ObjectId("6464acb09947e03e45b78b61"), "ProjectId": "64635ac02286d48c0c0d5907", "LabelValues": { "62d12558d75c134f54911490": "Nicht zuzuordnen", "62d12546d75c134f5491148f": "Nicht zuzuordnen" }, "KnowledgeItemId": ObjectId("6464acaf9947e03e45b78b60") } I want to write a query, that gets this element if I pass the two…
Basically, I am trying to create a tag search system for images, in which each image has an array of tags within a jsonb field image_data, like so: id image_data 1 {tags: ['landscape', 'dog']} 2 {tags: ['landscape', 'cat']} 3 {tags:…
In a PostgreSQL 14 database I have a transactions table currently containing around 400 million elements and the following query on it: SELECT "transactions"."id" FROM "transactions" WHERE ("wallet_id" = $1) ORDER BY "transactions"."id" DESC LIMIT 10 This works fine and…
Following the Firebase Database Setup, I can't Read/Write anything. I've been googling for hours trying different approaches and nothing is working. I'm using Discord.js so I'll remove the stuff unrelated to Firebase. For now I'm just hard coding the values…