All Questions

I have this query my goal is to get percent NVL(ROUND(100 * NVL(activeCount, 0) / NULLIF((NVL(activeCount, 0) + NVL(blockCount, 0) + NVL(closeCount, 0) + NVL(draftCount, 0)), 0), 0), 0) AS ...

I am trying to count how many orders each customer has. I noticed that COUNT(*) and COUNT(o.order_id) return different results and I don’t fully understand why. Here is a simplified example: CREATE ...

I am trying to list all customers, and show their orders if they have any. If a customer doesn't have any orders, I still want to see the customer in the result. CREATE TABLE customers ( ...

[enter image description here][1] I have been trying to connect my Supabase to my cursor project and for that I ran the SQL code shown below in the SQL editor of Supabase. My code from cursor: -- ...

I am trying to determine if it's possible to query for data between two defined HOUR values from a DateTime value, instead of writing out each DateTime iteration. This need is to find matching values ...

I'm calling a function with "paired" arguments: WITH ts AS ( SELECT t.c1, t.c2 FROM t ) -- `ORDER BY` to guarantee the same order SELECT f( a => ARRAY( SELECT ts.c1 FROM ts ...

I'm creating a function in Postgresql to bring data based on the user's name, but when I don't pass a name in the argument it should bring all the appointments independent of the name, but I'm getting ...

So I am learning how to use SQL on Python and I sometimes struggle to remember which functions to use and how to remember to enter them correctly, compared to BigQuery and MySQL which are kind of ...

Currently getting into SQL data cleaning and querying and looking forward to building dashboards and data visualization using BI tools. As a beginner, how do I start with GitHub to create a portfolio ...

I want the recursive bit that goes down in values be the values of c in the pc table and up in values be the plus_one recursive formula until the value from plus_one is greater than the one coming ...

I need to build the following XML data structure. I get the XML structure that I need but I am missing the student tag. <users> <user> <id>123</id> <name&...

I have a parent table created by the following statement: Create Table "GL_Cash_Book" ( "y_trans_code" Integer Not Null, "trans_date" Integer Default ...

I have a query on my SQLite3 database where one of the columns results in JSON, produced via the built-in JSON functions. When I set the output format to JSON as well, I would have expected that this ...

I have created the following view (below) now I need to edit it to include showing the WOTEMPLATEID as the DESCRIPTION: SELECT WOTEMPLATEID, COUNT(AR) AS Armondale, COUNT(CB) AS [Central Business ...

In one of my projects I have an entity with startDate (from) and expiryDate (to): @Entity public class BlacklistedItem { //... @Column(nullable = false) private LocalDateTime startDate; @...