How to write a query that returns the id of the managers in the department of which no more than 5 people work? I have a data table employee id integer - id employee name char - name employee department_id…
I have a Postgres DB setup, and I'm trying to return a certain data shape back from a query. My data looks like this: CREATE TABLE resource_actions( resource TEXT NOT NULL, actions TEXT NOT NULL, entity TEXT NOT NULL, UNIQUE(resource,…
I hate asking for help (in general) but also on here because most of my issues are probably easily solvable, but I'm new-ish to programming and cannot get past this bug. I'm developing a C# application that takes user input…
I have a column in my table with the name: efcodmov, every start of the month I need to extract all registers from the last month end of the code: AND efdtmov BETWEEN date('2023-01-01') AND date('2023-01-31') How can I modify…
I have the following table (simplified): CUSTOMER_ID NAME PHONE AGE HEIGHT 1 MANOLO 987456321 56 1.80 1 MANOLO NULL 56 1.79 2 LUCÍA NULL 56 1.50 2 LUCÍA 987456321 56 1.50 And the result I expect is to select only…
I have two tables, one is for measurements and every 3 seconds or so a value is written in a very simple structure: Measurements: timestamp value 1679474929 516 1679474933 501 1679474936 505 While the second contains all meta information, trigger…
ERROR: column "sams_ar_pb_rebuild.plan_units_ty" must appear in the GROUP BY clause or be used in an aggregate function select channel, category, club, week_ending, sum(eligible_units_ty) as "Eligible Units", sum(eligible_revenue_ty)::numeric as "Eligible Revenue", sum(plan_units_ty) as "Plan Units", sum(plan_revenue_ty)::numeric::money as "Plan Revnue", case when…
I have three tables in sql order_table (order_id, product_id, amount) products_table (product_id, name, price_usd), all_orders (order_id, customer_id, order_date, total_amount), I would like to produce a sql query which outputs the total revenue for each product by month for the last…
I have a set of (dance) performances (https://dbfiddle.uk/jMl5dgRK), where each performance has a related piece, a venue, a season and a date. Most pieces have been performed several times during a season. In some cases, several performances took place at…
Table create script: CREATE TABLE data (account_id int, cust_status varchar(25), amount int, date date); INSERT INTO data VALUES ('1', 'first_login', '1000', '01/01/2021'), ('1', 'sale', '500', '28/01/2021'), ('2', 'first_login', '2000', '07/03/2021'), ('3', 'first_login', '1000', '01/06/2021'), ('3', 'sale', '2000', '05/08/2021'), ('4', 'first_login',…